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

449 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
folkie1336961(None) 
folkier14359041folkier
folkies143612251folkies
alkie95520032_alkie
bookie123516002bookie
collie83621992collie
cookie123716042cookie
falsie93513852falsie
flooie93712152flooie
fogie96719002fo_gie
folate93320392folate
folia83618932fol_ia
folic105319322fol_ic
folio83820882fol_io
folk116021542folk__
folkiest15319502folkiest
folkish1736562folkish
folklife1842962folklife
folklike1434772folklike
folks126017122folk_s
folksier1533532folksier
folksy16484982folksy
folky159214712folk_y
follies103618942follies
follis93113902follis
foodie104413842foodie
footie94718142footie
forkier144311592forkier
foxlike21226222foxlike
honkie133011672honkie
kookie9389842kookie
mollie83517102mollie
nookie103712432nookie
oldie6415472_oldie
rookie103613262rookie
selkie102811692selkie
silkie103313402silkie
talkie103914442talkie
yolkier14336122yolkier
alike95523963_alike
alkies104518093_alkies
alkine104916803_alkine
axlike17388853axlike
balkier134111983balkier
belie75630383bel_ie
belike124616283belike
bikie113915883_bikie
billie85019173billie
birkie124110133birkie
bloke114316633blok_e
blooie83913193blooie
boccie123311453boccie
bodkin1338923bodkin
bogie89524103bo_gie
bole66448693bol__e
bolete8519613bolete
bolide9515563bolide
bollix1538053bollix
bolshie1247123bolshie
bonnie85314853bonnie
boobie104015293boobie
boogie93515993boogie
bookies133819403bookies
bootie85421163bootie
boskier13309173boskier
bougie93613273bougie
bowlike16349473bowlike
boxlike20267073boxlike
brookie1347373brookie
bulkier134111513bulkier
calkin123515493calkin
cockier154013623cockier
cockle143913573cockle
coke107038383co_k_e
cole66956113col__e
colic95726173col_ic
colies84837053col_ies
colin76231693col_in
collide103214793collide
collied103316673collied
collier93618153collier
collies94326583collies
colone85425003colone
colure8314163colure
commie124215523commie
cookies133719273cookies
coolie83821603coolie
cootie84223093cootie
corbie103618203corbie
corkier133114303corkier
corrie83621233corrie
cosie74728263co_sie
cowpie133511513cowpie
cowrie113814283cowrie
cozie163519133co_zie
darkie113714013darkie
dickie133913113dickie
dobie84920333do_bie
doggie93910893doggie
dogie75222793do_gie
doglike13207453doglike
dolce85816683dol_ce
dolci84912603dolci_
dole56550003dol__e
dollied93811143dollied
dollies83620983dollies
donsie7613643donsie
doobie94712683doobie
doolie73916833doolie
doozie163910653doozie
dorkier122810023dorkier
dormie9312623dormie
dovekie15134313dovekie
dowie94721143do_wie
doxie136017153do_xie
duckie133511663duckie
fadlike15318483fadlike
faerie93514683faerie
fake115534943f_ak_e
fakir125111493f_akir
false84818123fal_se
falsies103515013falsies
fanlike142610503fanlike
farcie114816473farcie
fatlike142911193fatlike
feirie939553feirie
felid94717173fel_id
feline94820143feline
fellies104119743fellies
felloe93513923felloe
felsic1147053felsic
felsite1039083felsite
ferlie92814053ferlie
fickle153912973fickle
fie67152443f___ie
file75446643fil__e
fille84327403fil_le
fillies103420253fillies
fillip11268953fillip
filmi105914003filmi_
filmic13348453filmic
filmier1237503filmier
filmis114610283filmis
filose96112503filose
finlike14279063finlike
firkin1337823firkin
flail85316183f_lail
flair86114123f_lair
flake125119973f_lake
flakier143910203flakier
flame105124443f_lame
flare84823633f_lare
flee76238793f_l_ee
flic96223733f_l_ic
flied96519433f_l_ied
flier86023403f_l_ier
flies85630713f_l_ies
flip96324263f_l_ip
flir76422203f_l_ir
flit76539273f_l_it
flite85424963f_lite
flockier1745343flockier
floe76129773f_l_oe
floosie10378933floosie
floozie19295463floozie
florae94713883florae
florid10311453florid
florin9312653florin
flossie10337443flossie
flue75329853f_l_ue
fluid94013963f_luid
fluke125016893f_luke
flukier14397853flukier
flume106021173f_lume
flunkie1434513flunkie
flute86823753f_lute
flyte115713943f_lyte
foamier12339003foamier
foamlike1735143foamlike
foci94521013fo_ci_
foe66350813fo___e
foetid10510513foetid
foggier12349913foggier
fogies104118063fo_gies
foible11410383foible
foil76433913fo__il
foin77231563fo__in
folacin1238053folacin
folates103218453folates
fold86528943fol__d
folded114212793folded
folder104317543folder
folding123912443folding
folds95221693fol_ds
foldup1233813foldup
foley115222303fol_ey
foleys123810463foleys
foliage1147533foliage
foliar93210973foliar
foliate10513533foliate
folioed1138033folioed
folios93915463folios
foliose10378013foliose
folium11310453folium
folklives1942673folklives
folklore1543473folklore
folkmot1675683folkmot
folkmote1763343folkmote
folksiest1643983folksiest
folksily1843443folksily
folktale1542873folktale
folkway2043353folkway
folles93820473folles
follicle1344393follicle
follow124010353follow
folly115022603fol_ly
fomite113314073fomite
fondle104412943fondle
fondue104510493fondue
foodies113416753foodies
footier104115113footier
footies103721543footies
footle93914383footle
footlike1537253footlike
footsie1047653footsie
foozle18369203foozle
forage104617003forage
forbid123312433forbid
forbye14427883forbye
force105324273fo_rce
fordid113512053fordid
fore78351473fo__re
forge95126943fo_rge
forgive1436193forgive
fork115930943fork__
forked145217143forked
forker134717903forker
forkiest153812303forkiest
forking154014843forking
forklike1435813forklike
forks125324683fork_s
forky156119643fork_y
forme105225993fo_rme
formee113919943formee
formic13310453formic
fornix1636033fornix
forrit91916623forrit
forte86131463fo_rte
forties104323863forties
fortis95418613fortis
fossae95510373fossae
fosse86119463fo_sse
fossil9379353fossil
foveae1237563foveae
foxfire2042563foxfire
foxier163910033fo_xier
foxskin2143133foxskin
fozier183710663fo_zier
froglike1634363froglike
frolic1149203frol_ic
fulfil1246423fulfil
fulgid1137043fulgid
fulmine1257963fulmine
funkia1336343funkia
funkier14349983funkier
fyke145915293f_yk_e
gillie74816943gillie
goalie7413163goalie
godlike1387563godlike
goodie83613993goodie
goonie73615563goonie
hackie154615623hackie
hankie133915713hankie
hawkie163810093hawkie
hickie153812473hickie
hoagie102310013hoagie
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
hogtie102711773hogtie
hoke115935933ho_k_e
hokier134214033ho_kier
hole77553393hol__e
holier94921623hol_ier
holies94630033hol_ies
holk116027943holk__
holked144913663holked
holking153512313holking
holks124720563holk_s
hollies103420813hollies
holmic1338783holmic
homie104622533ho_mie
honkies143015143honkies
hoodie105116143hoodie
hookier143811673hookier
hookies144017443hookies
hoolie93217783hoolie
hottie92514383hottie
howdie13349733howdie
hulkier14328973hulkier
hunkie133812383hunkie
iolite63221983iolite
joke155926163jo_k_e
jokier17618753jo_kier
jole117233823jol__e
jollied15349273jollied
jollier142911003jollier
jollies143516273jollies
joltier14318493joltier
junkie17339603junkie
kelpie12308613kelpie
killie104114893killie
kiltie103210963kiltie
kolkoz1864283kolkoz
kookier10398283kookier
koppie14277883koppie
lie38264523__l_ie
like86040843__like
loggie84011993loggie
lollies73116923lollies
looie55624243lo_oie
loonie64216453loonie
louie55023513lo_uie
luckie123611413luckie
malkin122913153malkin
milkier133411163milkier
moggie103210103moggie
moke106234223mo_k_e
moldier103110033moldier
mole66251833mol__e
molies84429513mol_ies
moline84422033moline
mollies93420233mollies
monie75631653mo_nie
movie105319133mo_vie
moxie144018123mo_xie
muskie123412543muskie
nellie63614813nellie
noogie73612313noogie
nookies113414963nookies
oakier104011393_oakier
oke75839483_o_k_e
oldies7314423_oldies
ole37155213_ol__e
oleic7313333_oleic
olein5316003_olein
oleine6313793_oleine
olio46829673_ol_io
olive84817153_olive
oolite63319603oolite
oorie53026363_oorie
ourie54027303_ourie
oxlike17307473oxlike
pinkie124414273pinkie
plie65127393_pl_ie
pockier153911603pockier
podlike14108553podlike
poke105335363po_k_e
pokier124914633po_kier
pokies125921333po_kies
pole65951303pol__e
poleis86018353poleis
police102918563police
polies84034583pol_ies
polio75722553pol_io
polis74731163pol_is
polite83625073polite
polka11310413polk_a
polkaed1435323polkaed
polkas1239103polkas
pollee83623273pollee
pommie123710503pommie
popsie103013053popsie
porkier133712343porkier
porkies133416493porkies
porkpie1544673porkpie
postie84123963postie
potlike13910123potlike
potpie103412433potpie
potsie83916033potsie
punkie123513613punkie
roadie72813813roadie
rockier134911883rockier
rodlike1288263rodlike
role45851823rol__e
roofie93411173roofie
rookier114012383rookier
rookies113917103rookies
roomie83013873roomie
saltie63422433saltie
selkies113513353selkies
sickie123715743sickie
silkier114411643silkier
silkies113715693silkies
softie93312483softie
soke85436263so_k_e
solace83415823solace
solate64526073solate
soldi65717203soldi_
soldier82812153soldier
sole46053673sol__e
solei55624343solei_
soli46637013sol_i_
solid65025083sol_id
solute64016663solute
solve85618943sol_ve
sonlike112110713sonlike
sonsie6614863sonsie
sortie63621993sortie
sulkier113811963sulkier
sulkies114315763sulkies
talkier114011843talkier
talkies113415733talkies
tekkie934203tekkie
toelike11149823toelike
toke86738493to_k_e
tolane64316583tolane
tole46052903tol__e
toluic837693toluic
toluid738213toluid
toluide835263toluide
toonie63617993toonie
towie85821873to_wie
townie93312303townie
toylike14157243toylike
unlike102614063unlike
vogie95116663vo_gie
vole75236983vol__e
volte85321303vol_te
volti84915963volti_
volume11358273volume
volute93912763volute
wallie93216803wallie
welkin1337313welkin
wellie92814913wellie
willie94116453willie
woke115527963wo_k_e
wonkier1437423wonkier
woodie103513613woodie
woolie93514483woolie
yoke115626393yo_k_e
yolk116218993yolk__
yolked14367153yolked
yolkiest15286693yolkiest
yolks125412773yolk_s
yolky15529523yolk_y
yowie114616453yo_wie
zombie1937323zombie
zowie174313843zo_wie

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164496.76616659.2
3Display Results4494490.1562878.2
 (SQL Overall)1786914497.31224438.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.