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

438 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
gillied9551231(None) 
gallied94115001gallied
gilled84521631gill_ed
gillie74816941gillie_
gillies84120961gillies
gullied93812061gullied
willied114611561willied
allied74217152_allied
bellied104314072bellied
billed94224902bill_ed
billie85019172billie_
billies93923502billies
bullied104514812bullied
collied103316672collied
cullied104012352cullied
dallied93713612dallied
dilled84122222dill_ed
dillies84122162dillies
dollied93811142dollied
filled104922262fill_ed
fillies103420252fillies
filliped1435222filliped
galled84622862gall_ed
gallies84122712gallies
gelled84718892gell_ed
ghillie11326352ghillie_
ghillies12408662ghillies
giddied11257712giddied
gilded94413222gi_lded
giller74519732gill_er
gilling93520382gilling
gillnet839732gillnet
gipsied1135872gipsied
girlie73711462girlie_
girlier8289522girlier
girlies83013702girlies
grilled94012832grill_ed
gulled84521372gull_ed
gullies84717312gullies
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
tallied83314752tallied
tilled74722952till_ed
willed104722452will_ed
willie94116452willie_
willies103920152willies
ailed66240283ai_l_ed
aisled74516183aisl_ed
alibied1038143alibied
allies63827673_allies
applied1247483applied
balled94926893ball_ed
ballies93725743ballies
belied95022163_belied
belled94626183bell_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
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
gabled105518453gabl_ed
gainlier965673gainlier
galilee8312213galilee
gallein8299043gallein
galleried1146923galleried
gallet73630853gall_et
galleted1038213galleted
galley104215453gall_ey
galliard10125753galliard
gallic9411643galli_c
gallica1047463gallica
galling93921963galling
galliot82214133galliot
gallium1037943gallium
galloped12107143galloped
gallused1034193gallused
galoped11138073galoped
gaoled84814503gaol_ed
gelated93615633gelated
gelded94512113g_elded
gelid74916983g_eli_d
gelling93219763gelling
gibbed124512353gi_bbed
gibed96215963gi__bed
giblet93418893gibl_et
giddier10308723giddier
giddies103713363giddies
gied64631983g___ied
gifted114510703gi_fted
gigged104112293gi_gged
giggled114010073giggled
gigglier1154323gigglier
giglet83920273gigl_et
gild65526513gi_l__d
gilder84415533gi_lder
gilding103813003gilding
gill56336183gill___
gillers84216903gillers
gillnets934733gillnets
gills64728193gill__s
gilly94321633gill__y
gillying13306813gillying
gilthead1343323gilthead
gimlet93716663giml_et
gimleted1243973gimleted
gimmie11298183gimmie_
gimmies123010113gimmies
gimped123911473gi_mped
gimpier12247943gimpier
ginned83813983gi_nned
ginnier8298983ginnier
gipped124815903gi_pped
gipsies1039903gipsies
girded93712493gi_rded
girdled10217453girdled
girliest93010403girliest
girlish1137193girlish
girned84010513gi_rned
girted83912873gi_rted
girthed12266243girthed
gitted84015053gi_tted
glaired9387743g_laired
glaived12375973g_laived
glared84715193g_lared
glazed174711773g_lazed
gled65631143g__l_ed
gleed75320573g__leed
gleyed11478153g_leyed
glide74521593g__lide
glided94513903g_lided
glimed105312283g_limed
glinted9399373glinted
glitzed18375493glitzed
globed104811763g_lobed
gloried9169513gloried
gloved114811873g_loved
glowed114913833g_lowed
glozed173711223g_lozed
glued75118363g__lued
gluier7310263g_luier
goaled85014363goal_ed
goalie7413163goalie_
goalies8316023goalies
godlier938893godlier
golfed11569763g_olfed
grillade1085143grillade
grille74315743grill_e_
griller84513353grill_er
grilles83715023grill_es
grilling103811533grilling
grislier935793grislier
guiled84315383guil_ed
guiltier934493guiltier
gulfed114810013g_ulfed
gulfier1137793gulfier
gullet74924833gull_et
gulley104213163gull_ey
gulling94019563gulling
gulped104610373g_ulped
gulpier1046953gulpier
gussied9267193gussied
gypsied1443263gypsied
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
stilled83314783still_ed
stillier868823stillier
sullies74122233sullies
swilled113611833swill_ed
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
twilled11398033twill_ed
uglified1345293uglified
unallied938393unallied
vialed105112593vial_ed
vialled1156843vialled
vilified1547243vilified
villae95615383villae_
villein1036753villein
villi86517853villi__
walled104021293wall_ed
wallie93216803wallie_
wallies103320743wallies
welled103820213well_ed
wellie92814913wellie_
wellies103719073wellies
wielded12216683wielded
wilded113714503wi_lded
wiled95231553wi_l_ed
wilier93217073wi_lier
willer94021063will_er
willet95124833will_et
willing113821613willing
willowed15156763willowed
wilted103915713wi_lted
yelled104116253yell_ed
yielded12184713yielded
zillion16188773zillion

Search took 7 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.406440125.6
2DLD Change Limit1340274386.18621666.2
3Display Results4384380.1562807.7
 (SQL Overall)1786914386.74826480.6
 
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.