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

363 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
foozle1836920(None) 
footle93914381footle
foozled20346891foozled
foozler19397591foozler
foozles19329541foozles
boodle93215032boodle
booze164718912booz_e
doodle83212852doodle
doozie163910652doozie
fizzle17369712fizzle
floozie19295462floozie
foible11410382foible
fondle104412942fondle
foodie104413842foodie
fool75330592foo_l_
fooled104317822foo_led
fools86824202foo_ls
footie94718142footie
footled113610762footled
footler104011872footler
footles103715712footles
foozlers20346072foozlers
froze174515652froz_e
noodle73212542noodle
nozzle14236632nozzle
ooze136420602_ooz_e
poodle93112042poodle
pozole1758912pozole
rootle63214452rootle
snoozle16305912snoozle
tootle62613812tootle
touzle15429002touzle
adoze155713833adoz_e
amole75724593amo_le
anole55330383ano_le
azole145118033azo_le
bobble94115143bobble
boggle104511943boggle
bogle85821683_bogle
bole66448693_bo_le
bonze165119353bonz_e
boobie104015293boobie
boodled113410933boodled
boodler103312003boodler
boodles103416043boodles
boogie93515993boogie
bookie123516003bookie
booklet132312643booklet
boomlet112412273boomlet
bootee84323023bootee
bootie85421163bootie
bootleg10276633bootleg
boozed184813833boozed
boozer174815963boozer
boozes174916523boozes
boozier18349013boozier
boozily2135623boozily
boozy194917063booz_y
bottle84916073bottle
boucle103712783boucle
boule74828043_boule
boulle84614613boulle
cloze165517543cloz_e
cobble123615263cobble
coble94823173_coble
cockle143913573cockle
coddle104713853coddle
coffle14359043coffle
cole66956113_co_le
cooee74531023coo_ee
cookie123716043cookie
cool66940493coo_l_
cooled95224593coo_led
cooler84824713coo_ler
coolie83821603coolie
coolly114811393coolly
cools75632633coo_ls
cooly105525423coo_ly
coombe124110093coombe
cootie84223093cootie
couple104415963couple
cozie163519133_cozie
croze164719453croz_e
dazzle1536853dazzle
dhole95215363dho_le
doable93115243doable
docile94213123docile
dole56550003_do_le
dongle83612493dongle
donzel1636313donzel
doobie94712683doobie
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doolee73018953doolee
doolie73916833doolie
dooly94821803doo_ly
doozer163910463doozer
doozies173812723doozies
doozy186813713dooz_y
dottle74212503dottle
double94013993double
doze145829083_doz_e
etoile6312263etoile
fable105824753f_able
facile112514883facile
faille93414743faille
farle86929243f_arle
faze165630043f_az_e
feaze175216313feaz_e
feeble1138253feeble
feeze174913823feez_e
female11310553female
ferule93413203ferule
fettle93713123fettle
fickle153912973fickle
fiddle113613383fiddle
file75446643f__ile
fille84327403f_ille
fimble133611753fimble
finale94116763finale
fipple13329063fipple
fizzled19357273fizzled
fizzles18339063fizzles
floe76129773flo__e
flooie93712153flooie
floosie10378933floosie
floozies20326953floozies
floozy21356613flooz_y
florae94713883florae
foal76630923f_oal_
foaled104515963f_oaled
foals85721693f_oals
focal104917673focal_
fodgel1136413fodgel
foe66350813f_o__e
fogie96719003f_ogie
foibles1238853foibles
foil76433913f_oil_
foiled104618403f_oiled
foils85025813f_oils
folate93320393folate
fold86528943f_o_ld
foley115222303f_o_ley
folk116021543f_o_lk
folkie13369613folkie
folles93820473f_olles
folly115022603f_olly
fomite113314073fomite
fondled12399423fondled
fondler11348883fondler
fondles113512613fondles
fondly13299043fondly
fondue104510493fondue
food86830573foo__d
foodies113416753foodies
foodless12338383foodless
foods95924163foo_ds
foolery1336693foo_lery
foot76248013foo__t
footage1148843footage
footed104418623footed
footer94320773footer
footier104115113footier
footies103721543footies
footlers113910793footlers
footless113710803footless
footlike1537253footlike
footmen1246583footmen
foots85528283foo_ts
footsie1047653footsie
footsy12587933footsy
footy115820533foo_ty
foozling21275723foozling
forage104617003forage
forbye14427883forbye
force105324273f_orce
fore78351473f_o_re
foreleg1137743foreleg
forge95126943f_orge
forme105225993f_orme
formee113919943formee
forte86131463f_orte
fossae95510373fossae
fosse86119463f_osse
foul77027583f_oul_
fouled104315973f_ouled
fouler93614903f_ouler
foully1239013foully
fouls87221433f_ouls
foveae1237563foveae
foveole13106873foveole
fowl105723633f_owl_
fowled133914103f_owled
fowler123712583f_owler
fowls115518893f_owls
foxhole2045073foxhole
foxily1947253foxily
fozier183710663f_ozier
fozy197017163f_oz_y
frazzle18305223frazzle
frizzle18367043frizzle
froe75329993fro__e
froglet11310063froglet
frore86218803fro_re
frozen18408443frozen
fuddle113312103fuddle
fugle94915543f_ugle
fumble133214263fumble
furze176815813furz_e
fusile94313493fusile
futile93914953futile
fuze166422373f_uz_e
fuzee175718883f_uzee
gloze154815983gloz_e
gobble113512983gobble
goggle94511573goggle
goodie83613993goodie
goodly11419303goodly
googly11417883googly
goonie73615563goonie
goose65925903goo_se
guzzle15297913guzzle
haole84820083hao_le
hobble133913433hobble
hole77553393_ho_le
hondle103914523hondle
hoodie105116143hoodie
hooklet142510813hooklet
hoolie93217783hoolie
hooly115022223hoo_ly
hoopla1147633hoopla
hoopoe11911233hoopoe
hopple132910483hopple
hoyle11314413_hoyle
joggle154010353joggle
jole117233823_jo_le
jostle13319863jostle
joule124918203_joule
kookie9389843kookie
lobule82910063lobule
locale83915653locale
locule83412033locule
looie55624243loo_ie
loonie64216453loonie
loose56627683loo_se
mizzle16279993mizzle
mobile103613543mobile
module93011033module
mole66251833_mo_le
monocle1139663monocle
mool67533863moo_l_
moola75117033moo_la
mooley11311633moo_ley
mools76027173moo_ls
moonlet92413273moonlet
moose76327193moo_se
morale85220553morale
motile83818343motile
mottle84116053mottle
muzzle16319393muzzle
nobble103814313nobble
noble74420993_noble
noddle83211363noddle
nodule7309803nodule
noodge8337583noodge
noodled9339923noodled
noodles83513193noodles
noogie73612313noogie
nookie103712433nookie
noose55624063noo_se
nozzles15276303nozzles
nuzzle14298083nuzzle
obole75917143_obole
odyle9349593_odyle
ogle56325053__ogle
ole37155213__o_le
oodles73517183_oodles
oorie53026363_oorie
oozed154214263_oozed
oozes145418713_oozes
oozier153610253_oozier
oozily18328073_oozily
oozy167018133_ooz_y
orle45630463__orle
ouzel144612323_ouzel
ovule839493_ovule
ozone14310613_ozone
people10310193people
pizzle16279493pizzle
pole65951303_po_le
poodles103013513poodles
pool65835953poo_l_
pooled94619813poo_led
pooler83819843poo_ler
pools74427703poo_ls
poorly1137893poorly
poove104514303poo_ve
popple92710983popple
posole8314223posole
pottle84416103pottle
pozoles1839063pozoles
prole74527793pro_le
puzzle16318603puzzle
roble75223023_roble
role45851823_ro_le
roofie93411173roofie
rookie103613263rookie
roomie83013873roomie
roose56127093roo_se
rootled83410533rootled
rootles73215633rootles
rootlet73015733rootlet
rouble83913313rouble
sizzle14309613sizzle
snooze15439993snooz_e
snoozled18344493snoozled
snoozles17335563snoozles
socle7419573_socle
sole46053673_so_le
soothe94214853soothe
sozzled16265183sozzled
stole54928813sto_le
teazle15329553teazle
thole85620843tho_le
toddle85811033toddle
toggle83810873toggle
toile54626493_toile
tole46052903_to_le
tool46735683too_l_
tooled74918903too_led
tooler63818613too_ler
tools55325243too_ls
toonie63617993toonie
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
topple104411323topple
tousle64514653tousle
touzled17367153touzled
touzles16359223touzles
voile84719723_voile
vole75236983_vo_le
whole114418093who_le
wobble133212313wobble
woodie103513613woodie
wool76427373woo_l_
wooled103715503woo_led
woolen93111373woo_len
wooler93615873woo_ler
woolie93514483woolie
woolled1136643woolled
woollen1034723woollen
woolly12408513woolly
wools84421463woo_ls
wooly114417673woo_ly
woozier19347323woozier
woozily2234383woozily
woozy204410603wooz_y
yodle94515043_yodle
zizzle13247313zizzle
zonule1577483zonule
zooglea1733373zooglea

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.406440125.6
2DLD Change Limit1127163635.62620034.8
3Display Results3633630.1232951.2
 (SQL Overall)1786913636.15529031.8
 
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.