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

368 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
doozie16391065(None) 
doobie94712681doobie
doolie73916831doolie
doozies173812721doozies
boobie104015292boobie
boogie93515992boogie
bookie123516002bookie
bootie85421162bootie
booze164718912booz_e
boozier18349012boozier
cookie123716042cookie
coolie83821602coolie
cootie84223092cootie
cozie163519132_cozie
dhootie1136472dhootie
dobie84920332d_obie
doggie93910892doggie
dogie75222792d_ogie
donsie7613642donsie
doobies103915672doobies
doodies94218772doodies
doodle83212852doodle
doolee73018952doolee
doolies83920712doolies
doomier103610122doomier
doozer163910462doozer
doozy186813712dooz_y
dormie9312622dormie
dowie94721142d_owie
doxie136017152d_oxie
doze145829082d_oz_e
dozier163611632d_ozier
floozie19295462floozie
foodie104413842foodie
footie94718142footie
foozle18369202foozle
goodie83613992goodie
goonie73615562goonie
hoodie105116142hoodie
hoolie93217782hoolie
kookie9389842kookie
looie55624242loo_ie
loonie64216452loonie
noogie73612312noogie
nookie103712432nookie
oorie53026362_oorie
ooze136420602_ooz_e
oozier153610252_oozier
roofie93411172roofie
rookie103613262rookie
roomie83013872roomie
toonie63617992toonie
woodie103513612woodie
woolie93514482woolie
woozier19347322woozier
adoze155713833adoz_e
anomie83215963anomie
blooie83913193blooie
boccie123311453boccie
bogie89524103_bogie
bonnie85314853bonnie
bonze165119353bonz_e
boobies113718203boobies
boodies103721443boodies
boodle93215033boodle
boogied11379283boogied
boogies103719013boogies
bookies133819403bookies
boomier113312183boomier
boonies93422483boonies
bootee84323023bootee
booties94124613booties
boozed184813833boozed
boozer174815963boozer
boozes174916523boozes
booziest19379263booziest
boozily2135623boozily
boozing194012163boozing
boozy194917063booz_y
bougie93613273bougie
brookie1347373brookie
cloze165517543cloz_e
collie83621993collie
commie124215523commie
cooee74531023coo_ee
cookies133719273cookies
coolies93824963coolies
coombe124110093coombe
coontie9311423coontie
cooties93725733cooties
corbie103618203corbie
corrie83621223corrie
cosie74728263_cosie
cowpie133511513cowpie
cowrie113814283cowrie
cozied184112153_cozied
cozier173315143_cozier
cozies174521413_cozies
croze164719453croz_e
crozier18369933crozier
darkie113714013darkie
dassie74615573dassie
dautie72914703dautie
dawtie103011093dawtie
daze147327233d_az_e
dazzle1536853dazzle
dearie73319813dearie
dexie134716893d_exie
dhobi1136973dhobi_
dhobis1236113dhobis
dhole95215363dho_le
dhoolies1246963dhoolies
dhooti1035663dhooti_
dhooties1237643dhooties
dhootis1135683dhootis
dhoti9310123dhoti_
dhotis1038973dhotis
diazin1639163diazin
diazine1738933diazine
dickie133913113dickie
didie74120563d_idie
die46759653d___ie
diode74716113dio_de
diorite8314913diorite
dioxid1568393dioxid
dioxide1656303dioxide
dioxin14118783dioxin
ditzier17307963ditzier
dizzied17236133dizzied
dizzier16317543dizzier
dizzies16279753dizzies
doable93115243doable
dobbies124113063dobbies
dobbin11339523dobbin
dobies94422093d_obies
docile94213123docile
dodge86618133d_odge
dodgier10388243dodgier
doe47361953d_o__e
doge66233803d_o_ge
doggier103810943doggier
doggies103613023doggies
dogies85022253d_ogies
doglike13207453doglike
doilies84017363doilies
doit56347853d_o_it
dolce85816683d_olce
dolci84912603dolci_
dole56550003d_o_le
dollied93811143dollied
dollies83620983dollies
dolomite1148133dolomite
domain9511323domain
domaine10610503domaine
dome77240733d_o_me
domic104317243d_omic
domine92918253domine
dominie103111643dominie
donate73619503donate
done55747913d_o_ne
donee66931013d_onee
dongle83612493dongle
donne65520463d_onne
donnee74317063donnee
donzel1636313donzel
doodad936423doodad
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doodoo8108893doodoo
doody105517913doo_dy
doofus1036163doofus
doolees83711613doolees
dooly94821803doo_ly
doom76430073doo__m
doomed104113293doomed
doomiest112910453doomiest
doomily1336133doomily
dooming113112533dooming
dooms85321343doo_ms
doomy116018263doo_my
door56928513doo__r
doormen1036753doormen
doors65022133doo_rs
doowop1283853doowop
doozers17419293doozers
dope76038893d_o_pe
dopier93515923d_opier
dore56353303d_o_re
dories75232363d_ories
dorkier122810023dorkier
dormice1237133dormice
dormin9312313dormin
dosage82810003dosage
dose56442433d_o_se
dossier83711693dossier
dossil75110903dossil
dotage82711613dotage
dote55442883d_o_te
dotier73917033d_otier
dottier83910923dottier
dottle74212503dottle
double94013993double
douce85518423d_ouce
douche124613223douche
dourine8311453dourine
douse66329723d_ouse
dove85131563d_o_ve
dovekie15134313dovekie
dowdier12328573dowdier
dowdies123412733dowdies
downier11299703downier
dowries114413983dowries
dowse96020813d_owse
doxies143917853d_oxies
doylies114512573doylies
dozed165619353d_ozed
dozen155017473d_ozen
dozer158419273d_ozer
dozes155226303d_ozes
doziest174012473d_oziest
dozily19329103d_ozily
dozing174214193d_ozing
dozy175920323d_oz_y
drogue8938333drogue
droid74218543dro_id
droit65127123dro_it
drone65324983dro_ne
droolier936073droolier
droopier1145573droopier
drove95518063dro_ve
drowse105010553drowse
duckie133511663duckie
duddie9348863duddie
duomi8310133duomi_
durrie73713263durrie
flooie93712153flooie
floosie10378933floosie
floozies20326953floozies
fogie96719003_fogie
folkie13369613folkie
foodies113416753foodies
footier104115113footier
footies103721543footies
footle93914383footle
footsie1047653footsie
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
fozier183710663_fozier
froze174515653froz_e
gloze154815983gloz_e
goalie7413163goalie
goodies93516993goodies
goofier11339313goofier
gooier73516213goo_ier
goonier83612843goonier
goonies83618333goonies
goopier103910573goopier
goose65925903goo_se
goosier83512563goosier
hoagie102310013hoagie
hogtie102711773hogtie
homie104622533_homie
honkie133011673honkie
hoochie1537803hoochie
hoodier113812973hoodier
hoodies113419833hoodies
hookier143811673hookier
hookies144017443hookies
hoopoe11911233hoopoe
hootier104915353hootier
hottie92514383hottie
howdie13349733howdie
idolize1737783idolize
iodize164112593iodize
ionize154613873ionize
kookier10398283kookier
koppie14277883koppie
lezzie1435333lezzie
loggie84011993loggie
loobies93814103loobies
looies65025833loo_ies
loonier73312683loonier
loonies73919543loonies
loopier93711193loopier
loose56627683loo_se
louie55023513_louie
moggie103210103moggie
mollie83517103mollie
monie75631653_monie
moodier103212203moodier
moonier93714103moonier
moorier93113073moorier
moose76327193moo_se
movie105319133_movie
moxie144018123_moxie
noodge8337583noodge
noodle73212543noodle
noogies82814583noogies
nookies113414963nookies
noose55624063noo_se
nozzle14236633nozzle
odorize1737403odorize
oldie6415473_oldie
oolite63319603_oolite
ootid61416703_ootid
oozed154214263_oozed
oozes145418713_oozes
ooziest163411523_ooziest
oozily18328073_oozily
oozing163812203_oozing
oozy167018133_ooz_y
ourie54027303_ourie
ozone14310613_ozone
pommie123710503pommie
poodle93112043poodle
poori74816233poori_
pooris83916843pooris
poove104514303poo_ve
popsie103013053popsie
postie84123963postie
potpie103412433potpie
potsie83916033potsie
pozole1758913pozole
roadie72813813roadie
roofies103014413roofies
rookier114012383rookier
rookies113917103rookies
roomier93812243roomier
roomies93017243roomies
roose56127093roo_se
rootier74915393rootier
rootle63214453rootle
snooze15439993snooz_e
snoozier17185193snoozier
snoozle16305913snoozle
softie93312483softie
sonsie6614863sonsie
soothe94214853soothe
sootier73916613sootier
sortie63621993sortie
sozin14514543_sozin
sozine15712353_sozine
stogie7311323stogie
stoolie739723stoolie
toonies73719883toonies
tootle62613813tootle
tootsie737133tootsie
touzle15429003touzle
towie85821873_towie
townie93312303townie
twoonie1034423twoonie
vogie95116663_vogie
whoopie15295933whoopie
woodier113912063woodier
woodies113517153woodies
woolier103612353woolier
woolies104117363woolies
wooziest20327903wooziest
woozily2234383woozily
woozy204410603wooz_y
yowie114616453_yowie
zombie1937323zombie
zooid15312103zoo_id
zooier153411233zoo_ier
zootier163611173zootier
zowie174313843_zowie

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 Filter1786911127160.373479064.3
2DLD Change Limit1127163686.12618399.6
3Display Results3683680.1232991.9
 (SQL Overall)1786913686.62226984.4
 
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.