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

365 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
junkie1733960(None) 
hunkie133812381hunkie
junkier18339491junkier
junkies183711691junkies
punkie123513611punkie
auntie64317702auntie
duckie133511662duckie
flunkie1434512flunkie
funkia1336342funkia
funkier14349982funkier
gunkier12369552gunkier
hankie133915712hankie
honkie133011672honkie
hunkier144512142hunkier
hunkies143214502hunkies
juke154721662ju_k_e
jungle144012652jungle
junk155121032junk__
junked184311692junked
junker174213652junker
junket173815022junket
junkiest192610172junkiest
junking193910072junking
junkmen2033632junkmen
junks164815972junk_s
junky194513232junk_y
luckie123611412luckie
muskie123412542muskie
pinkie124414272pinkie
punkier133512792punkier
punkies134216802punkies
punkin123611522punkin
runkle103611542runkle
spunkie13215292spunkie
untie54425492_untie
alkie95520033_alkie
ankle95220253_ankle
aunties73920073aunties
bankit123617043bankit
bikie113915883_bikie
birkie124110133birkie
bonnie85314853bonnie
bookie123516003bookie
buckle144815193buckle
budgie104310343budgie
bulkier134111513bulkier
bumkin14308083bumkin
bundle94315573bundle
bungee96319773bungee
bungle97116113bungle
bunk105731353bunk__
bunked135118373bunked
bunker124519373bunker
bunking144016193bunking
bunko115514513bunk_o
bunkoed14356663bunkoed
bunkos124210323bunkos
bunks115125083bunk_s
bunkum1435983bunkum
bunnies94415003bunnies
buppie12288733buppie
burdie93615023burdie
burke115122763burk_e
burkite1337003burkite
burnie83715413burnie
buskin123811493buskin
cannie83819363cannie
chunkier17395883chunkier
clunkier14345793clunkier
cookie123716043cookie
cuddie104011173cuddie
cuke105824983cu_k_e
curie74533043cu_rie
currie84317263currie
cutie76925933cu_tie
darkie113714013darkie
dickie133913113dickie
dinkier123411503dinkier
dinkies123716033dinkies
donsie7613643donsie
duckier143911793duckier
duckies143613813duckies
duddie9348863duddie
duke95628103du_k_e
dunce86319263dun_ce
dune56137583dun__e
dungier9368583dungier
dunite7315013dunite
dunk96228573dunk__
dunked124315283dunked
dunker113616463dunker
dunking133813263dunking
dunks105621193dunk_s
dunlin739723dunlin
dunnite857333dunnite
durrie73713263durrie
duskier12409433duskier
flunkies1536393flunkies
folkie13369613folkie
fundi96814913fundi_
fundic12389083fundic
fungi95014133fungi_
fungic12387813fungic
funk115825623funk__
funked144214113funked
funker133915763funker
funkias1435383funkias
funkiest152810973funkiest
funkily1736513funkily
funking154013023funking
funks125318913funk_s
funky154315133funk_y
funnier103210173funnier
funnies104113603funnies
genie66124923gen_ie
gunfire1134743gunfire
gunite7414403gunite
gunk95423573gunk__
gunkiest132610573gunkiest
gunks104517723gunk_s
gunky135514113gunk_y
gunnies83413123gunnies
gussie72910153gussie
hackie154615623hackie
hankies143617763hankies
hawkie163810093hawkie
hickie153812473hickie
hinkier143610793hinkier
honkies143015143honkies
huckle153913073huckle
hulkier14328973hulkier
hunk116029543hunk__
hunker133917673hunker
hunkey164210883hunkey
hunkiest153812333hunkiest
hunks125321453hunk_s
hunky155417733hunk_y
huskier14369763huskier
huskies143212083huskies
indie63721473_indie
inkier104013783_inkier
inkle94515833_inkle
jackies202912623jackies
jake155925773j_ak_e
jane115031483jan__e
jangle144416293jangle
jaunce15367433jaun_ce
jaundice1842013jaundice
jauntier1535233jauntier
jennies143511623jennies
jerkier18407273jerkier
jerkies183411583jerkies
jerkin17258113jerkin
jimmie17376473jimmie
jingle143815223jingle
jink156227203jink__
jinked184013143jinked
jinker174013543jinker
jinking193613543jinking
jinks165019333jink_s
jinnee13411573jinnee
jinni125310633jinni_
jinnis13489053jinnis
johnnie1772283johnnie
joke155926163j_ok_e
jokier17618753j_okier
jounce153310733joun_ce
jouncier1734423jouncier
jube136322783ju__be
jubile152910263jubile
judge144714153ju_dge
jugate14379463jugate
juggle154310283juggle
juice14311323ju_ice
juicier1635463juicier
jujube1442413jujube
juked175714073ju_ked
jukes165319103ju_kes
juking183810473ju_king
juku154414853ju_k_u
jukus16398673ju_kus
jumble174012653jumble
jumpier18317943jumpier
jun105932063jun___
junco144612203jun_co
juncoes16338073juncoes
juncos15449233juncos
jungled16349643jungled
jungles154112543jungles
junglier1644303junglier
jungly17407693jungly
junior1386143junior
juniper1634023juniper
junkers184010863junkers
junketed2033523junketed
junketer1943713junketer
junkets18377623junkets
junkman2043173junkman
junta123713673jun_ta
juntas134210503juntas
junto125114563jun_to
juntos134110843juntos
jupe134921003ju__pe
juried144212443ju_ried
juries134120633ju_ries
jussive1734293jussive
justice1637423justice
justle133211583justle
jute115327893ju__te
juttied15417863juttied
jutties143814003jutties
kinkier10319433kinkier
kookie9389843kookie
kune85424573kun__e
kunzite2053503kunzite
lankier113711633lankier
luckier133811533luckier
luckies133313683luckies
luggie8318903luggie
lunate6316043lunate
lune47140493lun__e
lunge65323803lun_ge
lungee75119813lungee
lungi65516053lungi_
lungis77113023lungis
lunier64617603lun_ier
lunies64723013lun_ies
lunk86030723lunk__
lunker104718343lunker
lunks94822453lunk_s
lunule638433lunule
minke115421763mink_e
monie75631653mon_ie
muckier153411483muckier
muckle143413583muckle
muni65824413mun_i_
munis75022003mun_is
muntin82915183muntin
murkier133110273murkier
muskier134312733muskier
muskies133614673muskies
muskit122813253muskit
nankin1039673nankin
nannie63713223nannie
nookie103712433nookie
nudie65118673nu_die
nuke85920753nu_k_e
nuncio837973nuncio
nuncle839363nuncle
nunlike11258073nunlike
ounce77019933oun_ce
ourie54027303ou_rie
outlie62419533outlie
outvie92412803outvie
pantie84326473pantie
pinkies133818263pinkies
plunkier14305323plunkier
puke105025463pu_k_e
pundit92914183pundit
pungle94413573pungle
punier84519223pun_ier
punji1438203punji_
punjis1536693punjis
punk105729973punk__
punka114515483punk_a
punkah15347093punkah
punkas123410673punkas
punker123718823punker
punkey154011173punkey
punkiest149312663punkiest
punkins133111113punkins
punkish16257693punkish
punks114822683punk_s
punky144419393punk_y
punnier93511263punnier
punties94520783punties
puttie84116303puttie
quake184114643quak_e
quakier20239203quakier
quickie2235513quickie
rankle103414883rankle
rookie103613263rookie
ruckle124414583ruckle
rundle73214233rundle
rune45236293run__e
runic73615773run_ic
runkled12399013runkled
runkles114111943runkles
runnier74010113runnier
runtier73512853runtier
selkie102811693selkie
sickie123715743sickie
silkie103313403silkie
skunkier11174283skunkier
sonsie6614863sonsie
spunkier14235813spunkier
spunkies14227583spunkies
suckier133613973suckier
suckle124015963suckle
sulkier113811963sulkier
sulkies114315763sulkies
sundae7312873sundae
sunk85031813sunk__
sunken103511783sunken
sunket103721363sunket
sunlike112310573sunlike
sunlit61516103sunlit
sunnier73412153sunnier
sunrise7310813sunrise
sunwise1036433sunwise
talkie103914443talkie
tekkie934203tekkie
tentie62521183tentie
tinkle103714453tinkle
tune45635863tun__e
tunic74018223tun_ic
tunnies73614263tunnies
tushie939723tushie
twinkie1434573twinkie
uke75727293_u_k_e
unai44824783_unai_
unais53420773_unais
unakin10310963_unakin
unakite1138743_unakite
unbe65319273_un_be
unbid83214643_unbid
unci65019463_unci_
uncia75015163_uncia
unciae83215313_unciae
uncle7317053_uncle
unde55825483_un_de
undee65327273_undee
undid72415363_undid
undies73821963_undies
undine7817263_undine
undue66715553_undue
unfit84518563_unfit
unfix15429033_unfix
unhip10178823_unhip
unit45140073_un_it
unite54828383_unite
unkind113310573_unkind
unkink9308713_unkink
unknit1068593_unknit
unlike102614063_unlike
unlit55025463_unlit
unlive92712333_unlive
unmix14388973_unmix
unpile81914323_unpile
unpin72613243_unpin
unrig61711413_unrig
unrip72012863_unrip
unripe82012093_unripe
untied73720813_untied
unties64326923_unties
until53517743_until
unwise9510803_unwise
unwit84417523_unwit
unzip16207623_unzip
vauntie1036633vauntie
winkle133812833winkle
wonkier1437423wonkier
yuckier16358533yuckier
yukkier13263893yukkier
yuppie13297133yuppie

Search took 6 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 Limit1127163654.72023880.5
3Display Results3653650.1232967.5
 (SQL Overall)1786913655.23334147.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.