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 “willied” 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.

473 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
willied11461156(None) 
gillied95512311gillied
willed104722451will_ed
willie94116451willie_
willies103920151willies
allied74217152_allied
bellied104314072bellied
billed94224902bill_ed
billie85019172billie_
billies93923502billies
bullied104514812bullied
collied103316672collied
cullied104012352cullied
dallied93713612dallied
dilled84122222dill_ed
dillies84122162dillies
dollied93811142dollied
filled104922262fill_ed
fillies103420252fillies
filliped1435222filliped
gallied94115002gallied
gilled84521632gill_ed
gillie74816942gillie_
gillies84120962gillies
gullied93812062gullied
hilled104022222hill_ed
hillier103413962hillier
hilloed113211292hilloed
jellied15419222jellied
jollied15349272jollied
killed113918772kill_ed
killie104114892killie_
killies113318112killies
lilied73913212li_lied
milled94326172mill_ed
millier93716702millier
milliped1337382milliped
nilled73919452nill_ed
pilled94222752pill_ed
rallied83514082rallied
rilled74525652rill_ed
sallied83316952sallied
sillier74017592sillier
sillies73425082sillies
sullied83714482sullied
swilled113611832swill_ed
tallied83314752tallied
tilled74722952till_ed
twilled11398032twill_ed
walled104021292wall_ed
wallie93216802wallie_
wallies103320742wallies
welled103820212well_ed
wellie92814912wellie_
wellies103719072wellies
wielded12216682wielded
wilded113714502wi_lded
wiled95231552wi_l_ed
wilier93217072wi_lier
willer94021062will_er
willet95124832will_et
willing113821612willing
willowed15156762willowed
wilted103915712wi_lted
ailed66240283ai_l_ed
aisled74516183aisl_ed
alibied1038143alibied
allies63827673_allies
applied1247483applied
balled94926893ball_ed
ballies93725743ballies
belied95022163_belied
belled94626193bell_ed
bellies94023723bellies
bialies93618413bialies
bielded11226713bielded
bilbies114712343bilbies
bilged105513183bi_lged
bilgier10358533bilgier
bilked134012943bi_lked
biller84923483bill_er
billet86029723bill_et
billeted1137643billeted
billhead1464433billhead
billiard1145873billiard
billing103823853billing
billion92212173billion
billowed14137063billowed
bilobed1235913bilobed
bilsted1038033bilsted
birdied11329433birdied
birled94416993birl_ed
bolled94722653boll_ed
bollixed1834483bollixed
bulled94626493bull_ed
bullier94116433bullier
bullies94121893bullies
called94126733call_ed
celled94420323cell_ed
chilled133310933chill_ed
chillier13328423chillier
chillies134113483chillies
citied94014143ci_tied
collide103214793collide
collided12309803collided
collie83621993collie_
collier93618153collier
collies94326583collies
culled94022473cull_ed
cullies94419963cullies
dallier84215373dallier
dallies84023193dallies
dellies83622213dellies
dialed84716453dial_ed
dialled9510133dialled
dilated93115823dilated
diluted9248933diluted
dirled84514903dirl_ed
dirtied93210853dirtied
disliked14288553disliked
divvied1544813divvied
dizzied17236133dizzied
dolled83518073doll_ed
dollies83620983dollies
drilled94711673drill_ed
dulled84719423dull_ed
dwelled12337593dwell_ed
felled103720303fell_ed
fellies104119743fellies
fielded12206813fielded
filched16307423filched
filed95331903fi_l_ed
fileted1159093fileted
fille84327403fill_e_
filler94623623fill_er
filles94224523fill_es
fillet95027083fill_et
filleted1236603filleted
filling113520803filling
fillip11268953filli_p
fillips12298133fillips
filmed124610363fi_lmed
filmier1237503filmier
flied96519433__flied
follies103618943follies
frilled113911603frill_ed
frillier1136513frillier
fulled103820653full_ed
galled84622863gall_ed
gallies84122713gallies
gelled84718893gell_ed
ghillie11326353ghillie_
ghillies12408663ghillies
giddied11257713giddied
gilded94413223gi_lded
giller74519733gill_er
gilling93520383gilling
gillnet839733gillnet
gipsied1135873gipsied
girlie73711463girlie_
girlier8289523girlier
girlies83013703girlies
grilled94012833grill_ed
gulled84521373gull_ed
gullies84717313gullies
halloed113314913halloed
helled104024703hell_ed
helloed113512423helloed
hiller94421633hill_er
hilliest113914113hilliest
hilling113821773hilling
hilloaed12136923hilloaed
hilloes103815963hilloes
hillside1254673hillside
hilted104016043hi_lted
hinnied11348103hinnied
hollaed11359853hollaed
hollies103420813hollies
holloed113812753holloed
hulled103920013hull_ed
hulloed11369793hulloed
idled74915213_idl_ed
iliad64613463_i_liad
iller54821293_ill_er
illite63414923_illite
illites72415013_illites
illude7327503_illude
illuded9305763_illuded
illumed10285863_illumed
implied1238623implied
inlier63615363_inlier
isled64615993_isl_ed
ivied94710523_i_vied
jelled144916063jell_ed
jellies143816533jellies
jillion14188933jillion
jilted144111353ji_lted
jimmied19275033jimmied
jollier142911003jollier
jollies143516273jollies
kellies113516853kellies
killdee1266223killdee
killer104917953kill_er
killick1295313killick
killing123118723killing
kilned11368393ki_lned
kilted113613833ki_lted
kiltie103210963kiltie_
kilties113014143kilties
lalled74218753lall_ed
lied55838093___lied
lilies63021413li_lies
lilted73715373li_lted
lolled74315823loll_ed
lollies73116923lollies
lulled74516443lull_ed
malled94626113mall_ed
melled95023023mell_ed
milded104416153mi_lded
milieu8314113mi_lieu
milked134612573mi_lked
milkier133411163milkier
mille75029133mill_e_
milleped1335173milleped
miller84625413mill_er
milles84526563mill_es
millet84030743mill_et
milliard1147033milliard
millieme12276803millieme
milliers102611903milliers
millime112511403millime
millimes122411373millimes
milline92519113milline
milliner102811863milliner
millines102718063millines
milling103223683milling
million91813143million
millipede1444223millipede
millipeds1444703millipeds
millirem1245693millirem
milted93919943mi_lted
miltier93214963miltier
misallied1246543misallied
misled94719313misl_ed
mislie83219153mislie_
mislies92922283mislies
misliked15319513misliked
mislived14328783mislived
mollie83517103mollie_
mollies93420233mollies
mulled94721553mull_ed
nellie63614813nellie_
nellies73418723nellies
nielloed963863nielloed
nilling83619563nilling
nulled74318273null_ed
oilbird1043743oilbird
oiled64429473oi_l_ed
oilier64417233oi_lier
oilseed835783oilseed
palled94625163pall_ed
pallid93915283palli_d
pallier94417163pallier
palsied102911303palsied
piled85232993pi_l_ed
pillaged12298093pillaged
pillared11228093pillared
pilling103722563pilling
pillion92011703pillion
pilloried1265313pilloried
pillowed14156383pillowed
piloted10310323piloted
pitied94017253pi_tied
plied85118593__plied
polled94022003poll_ed
prilled104713003prill_ed
pulled94322193pull_ed
quilled17329283quill_ed
rallier73816273rallier
rallies73823343rallies
relied74926233_relied
replied103914453replied
rifled104115003rifl_ed
riled65833253ri_l_ed
rille55728733rill_e_
rilles64725503rill_es
rillet64828853rill_et
rilling84023623rilling
rolled74220243roll_ed
sallier73320423sallier
sallies73227813sallies
shilled113313623shill_ed
sialid7314943siali_d
sicklied1546583sicklied
sidled84215173sidl_ed
silked114314813si_lked
silkie103313403silkie_
silkier114411643silkier
silkies113715693silkies
siller64026063sill_er
silliest84017103silliest
sillily10209783sillily
siloed74615303si_loed
silted74020013si_lted
siltier73413863siltier
skilled123110863skill_ed
spilled103613623spill_ed
stilled83314793still_ed
stillier868823stillier
sullies74122233sullies
swelled113211703swell_ed
swiller103211663swill_er
swilling123511933swilling
swirled11308223swirl_ed
swirlier1135213swirlier
tallier72817213tallier
tallies73624603tallies
tellies73820503tellies
tidied83613273ti_died
tiled64832943ti_l_ed
tiller64222543till_er
tillered937443tillered
tilling83522783tilling
tillite7313563tillite
tillites8312833tillites
tilted74616863ti_lted
tirled74714363tirl_ed
titled73815003titl_ed
tolled73819033toll_ed
trilled84116313trill_ed
trollied935893trollied
twilling12268673twilling
twirled11385983twirl_ed
twirlier1133513twirlier
unallied938393unallied
unwilled1277823unwill_ed
vialed105112593vial_ed
vialled1156843vialled
vilified1547243vilified
villae95615383villae_
villein1036753villein
villi86517853villi__
waddied13358563waddied
wailed104823593wail_ed
waled94330993w_al_ed
walies95324523w_alies
walked145313783w_alked
wallet93327093wall_et
walleyed1534153walleyed
walling113520973walling
walloped14146833walloped
wallowed15148163wallowed
waltzed2033493waltzed
wauled104713963waul_ed
wawled133811703wawl_ed
wearied112911803wearied
welched16298833welched
welded114013383w_elded
wellhead1543503wellhead
welling112920313welling
welshed14277203welshed
welted103715823w_elted
whaled134612033whal_ed
whelmed16375153whelmed
whelped16355633whelped
whiled134514133whil_ed
whimsied1743113whimsied
whinnied15284153whinnied
whirled14368043whirl_ed
whirlier14175293whirlier
whirlies14167373whirlies
whirried15154103whirried
wicked164317413wi_cked
widdie113410733widdie_
widdies123514033widdies
widdled133511233widdled
widened12328053widened
widowed1534843widowed
wield95213913wiel__d
wielder11197673wielder
wieldier1234283wieldier
wienie9229973wienie_
wienies102213683wienies
wifed125117743wi__fed
wifelier1434853wifelier
wiftier13297733wiftier
wigged124413583wi_gged
wiggier12418863wiggier
wiggled13299603wiggled
wigglier1354453wigglier
wiglet105519153wigl_et
wiglike15125853wiglike
wild85126513wi_l__d
wilder103616473wi_lder
wildered1336633wildered
wilding123814293wilding
wildish1446853wildish
wildland1353843wildland
wildlife1543253wildlife
wildling13248083wildling
wile75944373wi_l_e_
wiles85437873wi_l_es
wiliest103416593wi_liest
wilily123310763wi_lily
wiling103024293wi_ling
will75737513will___
willers103517913willers
willets104414323willets
willful1344533willful
willinger1343723willinger
williwau1452723williwau
williwaw1342323williwaw
willow12369693will_ow
willower14127453willower
willowier1563783willowier
willows13299753willows
willowy16276353willowy
wills84528963will__s
willy115321913will__y
willyard1543963willyard
willying15306713willying
wilting113515913wilting
wimbled15298153wimbled
wimped144211513wi_mped
wimpier14248053wimpier
wimpled15338823wimpled
winced124415343wi_nced
winched163110593winched
winded114918213wi_nded
windier113412163windier
windled123713483windled
wined94434183wi__ned
winged114620833wi_nged
wingier113413283wingier
winier94522453wi_nier
winked144018603wi_nked
winkled15299593winkled
winned104017013wi_nned
wintled11339843wintled
wiped114722083wi__ped
wired95327643wi__red
wirier94215553wi_rier
wised95123343wi__sed
wiselier1137363wiselier
wished134417513wi_shed
wisped123411893wi_sped
wispier12249403wispier
wissed104114643wi_ssed
wisted104120273wi_sted
witched163012193witched
wited94727143wi__ted
withed134416233wi_thed
withier132910493withier
withies133913543withies
witling113215813witling
witted104216813wi_tted
wittier103910823wittier
wived125121503wi__ved
wizened20275423wizened
wolfed13428013w_olfed
wooled103715503wool_ed
woolie93514483woolie_
woolier103612353woolier
woolies104117363woolies
woolled1136643woolled
woollier1155433woollier
woollies1147413woollies
worried11308693worried
wried95518563w__ried
wyled124611843w_yl_ed
yelled104116253yell_ed
yielded12184713yielded
zillion16188773zillion

Search took 8 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 Filter1786911340270.423422437.4
2DLD Change Limit1340274736.64020184.8
3Display Results4734730.1702782.4
 (SQL Overall)1786914737.23324705.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.