Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “wieldier” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

147 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
wieldier123428(None) 
wielder11197671wield_er
fielder11217412field_er
unwieldier1451652unwieldier
weedier113810622w_eedier
welder102914412w_eld_er
whelkier1833262whelkier
wielded12216682wield_ed
wielders12196612wield_ers
wieldiest1334802wieldiest
wielding13286862wielding
wifelier1434852wifel_ier
wilder103616472wi_ld_er
wilier93217072wi_l_ier
windier113412162wi_ndier
wiselier1137362wisel_ier
yielder11175112yield_er
atelier7311643atel_ier
beadier103513913_beadier
belier84423563_bel_ier
bendier103111413_bendier
bielded11226713bield_ed
bielding12237473bielding
bilgier10358533bi_lgier
deedier93011593_deedier
eelier64216463_eel_ier
elder64020023__eld_er
elmier839813__elmier
fielded12206813field_ed
fielders12156773field_ers
fielding13206863fielding
fierier103511193fie_rier
filmier1237503fi_lmier
gelder84613713_geld_er
giddier10308723gi_ddier
gilder84415533gi_ld_er
girlier8289523girl_ier
greedier1036083greedier
headier113212953_headier
hillier103413963hi_llier
inlier63615363_inl_ier
killdeer1362943killdeer
kindlier1345763kindlier
leadier83212723_leadier
lieder74912323lie_d_er
likelier1235283likel_ier
livelier1136873livel_ier
melder93915813_meld_er
milder93818453mi_ld_er
milkier133411163mi_lkier
millier93716703mi_llier
miltier93214963mi_ltier
moldier103110033_moldier
mouldier1154963mouldier
needier84010623_needier
nerdier83110363_nerdier
oilier64417233oi_l_ier
readier83117423_readier
reedier83815303_reedier
relier65826183_rel_ier
seedier83513633_seedier
shellier1138403shellier
shelvier1464913shelvier
shielder1235183shield_er
silkier114411643si_lkier
sillier74017593si_llier
siltier73413863si_ltier
smellier1036813smellier
soldier82812153_soldier
speedier1146623speedier
spendier1147143spendier
steadier937313steadier
swirlier1135213swirl_ier
tidier73515113ti__dier
timelier1036713timel_ier
trendier937913trendier
tweedier1253623tweedier
twiddlier1441863twiddlier
twirlier1133513twirl_ier
viewier1334983vie_wier
wearier103613293w_earier
webbier1445423w_ebbier
wedder113612303w_e_dder
wedgier12428283w_edgier
weeder103315513w_eed_er
weenier103210803w_eenier
weensier1134243weensier
weepier12319273w_eepier
weirder1144923weird_er
weirdie11224063weirdie_
weirdies12255783weirdies
welcher15319393w_elcher
welded114013383w_eld_ed
welders113313413w_eld_ers
welding123213253w_elding
weldor10317653w_eld_or
welldoer1243483welldoer
wellie92814913w_ellie_
wellies103719073w_ellies
welsher13377443w_elsher
welter93417383w_el_ter
wennier10318603w_ennier
wheedler1543553wheedler
wheezier2333353wheezier
whirlier14175293whirl_ier
widder112913973wi__dder
widdie113410733wi_ddie_
widdies123514033wi_ddies
wider94826363wi__d_er
wield95213913wield___
wields10469623wield__s
wieldy13476183wield__y
wiener94513543wie__ner
wienie9229973wie_nie_
wienies102213683wie_nies
wiftier13297733wi_ftier
wiggier12418863wi_ggier
wigglier1354453wigglier
wilded113714503wi_ld_ed
wilders113513503wi_ld_ers
wildfire1542803wi_ldfire
wilding123814293wi_lding
wildish1446853wi_ldish
willer94021063wi_l_ler
willie94116453wi_llie_
willied114611563wi_llied
willies103920153wi_llies
willower14127463willower
willowier1563783willowier
wimpier14248053wi_mpier
winder104025263wi_nd_er
wingier113413283wi_ngier
winier94522453wi__nier
wintrier1136873wintrier
wirier94215553wi__rier
wispier12249403wi_spier
witchier16307883witchier
withier132910493wi_thier
wittier103910823wi_ttier
woodier113912063w_oodier
woolier103612353wool_ier
woollier1155433woollier
wordier112511213w_ordier
worldlier1342163worldlier
yielded12184713yield_ed
yielders12164743yield_ers
yielding13205033yielding

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.423422437.4
2DLD Change Limit1461621478.59317009.4
3Display Results1471470.0632333.3
 (SQL Overall)1786911479.07919681.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.