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

395 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
foozles1932954(None) 
footles103715711footles
foozle18369201foozle_
foozled20346891foozled
foozler19397591foozler
foozlers20346071foozlers
boodles103416042boodles
boozes174916522booz_es
doodles93614162doodles
doozies173812722doozies
fizzles18339062fizzles
floozies20326952floozies
foibles1238852foibles
folles93820472f_olles
fondles113512612fondles
foodies113416752foodies
foodless12338382foodless
fooled104317822foo_led
fools86824202foo_l_s
footies103721542footies
footle93914382footle_
footled113610762footled
footler104011872footler
footlers113910792footlers
footless113710802footless
noodles83513192noodles
nozzles15276302nozzles
oodles73517182_oodles
oozes145418712_ooz_es
poodles103013512poodles
pozoles1839062pozoles
rootles73215632rootles
snoozles17335562snoozles
tootles72915602tootles
touzles16359222touzles
amoles84122193amo_les
anoles64827433ano_les
azoles154614613azo_les
bobbles104514913bobbles
boggles113411823boggles
bogles95020833_bogles
boles75448603_bo_les
bonzes175116103bonz_es
boobies113718203boobies
boodies103721443boodies
boodle93215033boodle_
boodled113410933boodled
boodler103312003boodler
boodlers113710743boodlers
boogies103719013boogies
bookies133819403bookies
booklet132312643booklet
booklets14247123booklets
boomlet112412273boomlet
boomlets12246673boomlets
boonies93422483boonies
boonless10328353boonless
bootees94114473bootees
booties94124613booties
bootleg10276633bootleg
bootlegs11325873bootlegs
bootless103410983bootless
booze164718913booz_e_
boozed184813833booz_ed
boozer174815963booz_er
boozers183912443boozers
boozier18349013boozier
booziest19379263booziest
bottles94216273bottles
boucles113113003boucles
boules84925973_boules
boulles93114123boulles
clozes174915563cloz_es
cobbles133814823cobbles
cobles104622883_cobles
cockles153414643cockles
coddles114213593coddles
coffles152610003coffles
coles76055063_co_les
cooches143515833cooches
cooees85621893coo_ees
cookies133719273cookies
cookless14258633cookless
cooled95224593coo_led
cooler84824713coo_ler
coolers93522493coo_lers
coolest9318643coo_lest
coolies93824963coolies
cools75632633coo_l_s
coombes133810663coombes
cooties93725733cooties
couples115317053couples
cozes166033243_coz_es
cozies174521413_cozies
cozzes164510893_cozzes
crozes174417663croz_es
dazzles1636413dazzles
dholes104914793dho_les
doles67843753_do_les
dongles93212873dongles
donzels1735393donzels
doobies103915673doobies
doodies94218773doodies
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodlers10338843doodlers
doolee73018953doo_lee
doolees83711613doolees
doolies83920713doolies
doorless936713doorless
doozer163910463dooz_er
doozers17419293doozers
doozie163910653doozie_
dottles83912283dottles
doubles103113353doubles
dozes155226303_doz_es
etoiles7411293etoiles
fables114921673f_ables
failles102914133failles
farles96025783f_arles
fazes175527213f_az_es
feazes184514173feaz_es
feezes184412613feez_es
females12310663females
ferules103112723ferules
fettles103912733fettles
fezes175220023f_ez_es
fezzes174910403f_ezzes
fiddles123212603fiddles
files85441273f__iles
filles94224523f_illes
fimbles143510663fimbles
finales104016013finales
fipples14298653fipples
fizzes174512553f_izzes
fizzle17369713fizzle_
fizzled19357273fizzled
floes85528143flo__es
floorless1243793floorless
floosies113210233floosies
floozie19295463floozie_
flosses103411973flosses
foaled104515963f_oaled
foals85721693f_oal_s
foamless13195843foamless
focuses12159653focuses
foes76543443f_o__es
fogies104118063f_ogies
fogless1138193f_ogless
foible11410383foible_
foiled104618403f_oiled
foils85025813f_oil_s
folates103218453folates
folds95221693f_o_lds
foley115222303f_o_ley
foleys123810463f_o_leys
folkies143612253folkies
folks126017123f_o_lks
follies103618943follies
follis93113903f_ollis
fomites123613203fomites
fondle104412943fondle_
fondled12399423fondled
fondler11348883fondler
fondlers12338023fondlers
fondues11399313fondues
foodie104413843foodie_
foods95924163foo__ds
fool75330593foo_l__
foolery1336693foo_lery
foolish1339613foo_lish
footages1239053footages
footed104418623foo_ted
footer94320773foo_ter
footers104618333footers
footie94718143footie_
footier104115113footier
footiest113514913footiest
footmen1246583footmen
footrest11308853footrest
foots85528283foo__ts
footsies1139643footsies
foozling21275723foozling
forages114217283forages
forces114422133f_orces
fordless12289003fordless
fordoes11311963fordoes
foreleg1137743foreleg
forelegs1236613forelegs
fores85847103f_o_res
forges105024263f_orges
forgoes11311353forgoes
forkless15267433forkless
formes114623713f_ormes
formless13248083formless
fortes95327183f_ortes
forties104323863forties
fosses96022083f_osses
fouled104315973f_ouled
fouler93614903f_ouler
foulest10313313f_oulest
fouls87221433f_oul_s
foveoles1496643foveoles
fowled133914103f_owled
fowler123712583f_owler
fowlers133411203f_owlers
fowls115518893f_owl_s
foxes156321093f_o_xes
foxholes2144693foxholes
fozier183710663f_ozier
foziest194110943f_oziest
frazzles19284813frazzles
frizes184015463friz_es
frizzes18338183frizzes
frizzles19297283frizzles
froes86126693fro__es
froglet11310063froglet
froglets1235263froglets
frontes104214163frontes
froze174515653froz_e_
frozen18408443froz_en
fuddles123611933fuddles
fugles104715783f_ugles
fumbles143514413fumbles
furzes186613693furz_es
futzes184313113futz_es
fuzees184910753f_uzees
fuzes175120223f_uz_es
fuzzes175412253f_uzzes
glozes164313353gloz_es
gobbles123512583gobbles
goggles103510793goggles
goodies93516993goodies
googlies1086763googlies
goonies83618333goonies
gooses75723063goo_ses
guzzles16328043guzzles
haoles94919803hao_les
hobbles143313783hobbles
holes84748653_ho_les
hondles113614523hondles
hooches153812523hooches
hoodies113419833hoodies
hoodless12289733hoodless
hoofless14258013hoofless
hookies144017443hookies
hookless151238363hookless
hooklet142510813hooklet
hooklets15217203hooklets
hooplas1239213hooplas
hoopless13279263hoopless
hoopoes121212483hoopoes
hooves124815493hoo_ves
hopples142810713hopples
hoyles12315013_hoyles
joggles164410413joggles
joles125230833_jo_les
jostles143411143jostles
joules134116823_joules
lobules92510813lobules
locales93715093locales
locules92812603locules
loobies93814103loobies
looies65025833loo_ies
loonies73919543loonies
looses67328253loo_ses
mizzles17329493mizzles
mobiles112813123mobiles
modules102511003modules
moles74747923_mo_les
monocles12310673monocles
mooches143714453mooches
moolas83615593moo_las
mooley11311633moo_ley
mooleys1236863moo_leys
mools76027173moo_l_s
moonless10278043moonless
moonlet92413273moonlet
moonlets10247473moonlets
morales93619403morales
motiles93317433motiles
mottles93415803mottles
muzzles17299683muzzles
nobbles114014523nobbles
nobles83319723_nobles
noddles92911293noddles
nodules8269703nodules
nombles113212343nombles
noodges9317713noodges
noodle73212543noodle_
noodled9339923noodled
noogies82814583noogies
nookies113414963nookies
nooses65623653noo_ses
nopales93812523nopales
nozzle14236633nozzle_
nuzzles15298123nuzzles
oboles83815833_oboles
odyles10348563_odyles
ogles65223183__ogles
oles46453473__o_les
ooze136420603_ooz_e_
oozed154214263_ooz_ed
oozier153610253_oozier
ooziest163411523_ooziest
orles55326213__orles
ouzels15408703_ouzels
ovules938223_ovules
ozones1539393_ozones
peoples11312223peoples
pizzles17329273pizzles
poles75351003_po_les
pooches143214163pooches
poodle93112043poodle_
pooled94619813poo_led
pooler83819843poo_ler
poolers94217423poo_lers
pools74427703poo_l_s
pooves113914713poo_ves
popples103011873popples
posoles9314883posoles
pottles93816983pottles
pozole1758913pozole_
proles84627203pro_les
puzzles17318973puzzles
robles85321693_robles
roles56747983_ro_les
roofies103014413roofies
roofless11316733roofless
rookies113917103rookies
roomies93017243roomies
rooses65526243roo_ses
rootle63214453rootle_
rootled83410533rootled
rootless83910443rootless
rootlet73015733rootlet
rootlets8308653rootlets
roubles93413513roubles
sizzles15349633sizzles
snoozes16289783snooz_es
snoozle16305913snoozle_
snoozled18344493snoozled
socles8418453_socles
soles55547923_so_les
soothes103917113soothes
sozzled16265183sozzled
stoles63927673sto_les
teazles16308923teazles
tholes94919783tho_les
toddles93211533toddles
toggles93710973toggles
toiles63923513_toiles
toles55147133_to_les
tooled74918903too_led
tooler63818613too_ler
toolers74416503too_lers
toolless836343toolless
tools55325243too_l_s
toonies73719883toonies
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootlers8289503tootlers
tootses72910773tootses
topples113111653topples
tousles74113933tousles
touzle15429003touzle_
touzled17367153touzled
voiles94616443_voiles
voles86234043_vo_les
wholes124616773who_les
wobbles143412433wobbles
woodies113517153woodies
woodless12278453woodless
wooled103715503woo_led
woolen93111373woo_len
woolens10398843woo_lens
wooler93615873woo_ler
woolers104214023woo_lers
woolies104117363woolies
woolled1136643woolled
woollen1034723woollen
woollens1144093woollens
woollies1147413woollies
wools84421463woo_l_s
woopses1237883woopses
wooshes13169883wooshes
woozier19347323woozier
wooziest20327903wooziest
yodles103714333_yodles
zizzles14307093zizzles
zonules1647793zonules
zooglea1733373zooglea
zoogleas1843373zoogleas

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 Filter1786911340270.420425454.8
2DLD Change Limit1340273956.69020033.9
3Display Results3953950.1402821.4
 (SQL Overall)1786913957.25024647.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.