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

340 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
hoopoes12121248(None) 
hoopoe11911231hoopoe_
hoopoos1298541hoopoos
hoboes114717442h_oboes
holloes103818192holloes
hooches153812522hooches
hoodies113419832hoodies
hoodoos11109292hoodoos
hookies144017442hookies
hooped125518182hoop_ed
hooper114518312hoop_er
hoopers123616482hoopers
hooplas1239192hooplas
hoopless13279252hoopless
hoopoo1198752hoopo_o
hoops105621072hoop__s
hooves124815482hoo_ves
hopes105835642h_op_es
hopples142810712hopples
whoopees16294822whoopees
whoopies16267372whoopies
woopses1237882woopses
atopies92816433atopies
bongoes104314113bongoes
boobies113718203boobies
booboos1138143booboos
boocoos1137753boocoos
boodies103721443boodies
boodles103416043boodles
boogies103719013boogies
boohoos1237993boohoos
bookies133819403bookies
bookoos1337503bookoos
boonies93422483boonies
bootees94114473bootees
booties94124613booties
boozes174916523boo_zes
bowpots1446023bowpots
chooses125717423choo_ses
compos124818803compo_s
compose135716663compose
composes145017113composes
compotes144716513compotes
condoes104319203condoes
congoes103617303congoes
cooches143515833cooches
cooees85621893coo_ees
cookies133719273cookies
coolies93824963coolies
coombes133810663coombes
cooped114821603coop_ed
cooper104221123coop_er
coopers114019483coopers
coops96229643coop__s
coopted123710763coopted
coopts105814583coop_ts
cooties93725733cooties
copes97747103_cop_es
copies104130303_copies
copses104922473_copses
corpses113913803corpses
coupes105022523coup_es
couples115317053couples
coupons112710563coupons
cowpies143314283cowpies
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
coypous14248813coypous
dhoolies1246963dhoolies
dhooties1237643dhooties
dodoes85716103_dodoes
doobies103915673doobies
doodies94218773doodies
doodles93614163doodles
doodoos9107623doodoos
doolees83711613doolees
doolies83920713doolies
doowops1363943doowops
doozies173812723doozies
dopes84935043_dop_es
elopes85918163elop_es
epopees1137233epopees
foodies113416753foodies
footies103721543footies
footles103715713footles
foozles19329543foozles
fordoes11311963fordoes
forgoes11311353forgoes
goboes95914443_goboes
gonopores1246523gonopores
goodies93516993goodies
googols935483googols
goonies83618333goonies
goopier103910573goopier
goopiest112710553goopiest
goops86620963goop__s
gooses75723053goo_ses
gropes95220403grop_es
halloes104021523halloes
haloes94623863h_aloes
haoles94919803hao_les
harpies123818313harpies
helloes103717463helloes
heroes94923823h_eroes
herpes115517323herp_es
hilloes103815963hilloes
hippies142813743hippies
hippos13408433hippo_s
hirples12149643hirples
hoagies112811993hoagies
hoaxes163611693h_oaxes
hobbies143813343hobbies
hobbles143313783hobbles
hobnobs1443603hobnobs
hoboed124511683h_oboed
hobos106321353h_obo_s
hocuses121710423hocuses
hoes75755733h___oes
hognose11117243hognose
hognoses12108133hognoses
hogties112813993hogties
hoises94823673h_oises
hokes126231643h_o_kes
holes84748653h_o_les
holies94630033h_olies
hollies103420813hollies
holloas103814943holloas
holloed113812753holloed
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
holpen11299413holp_en
homages131011583homages
hombres14369873hombres
homes106938813h_o_mes
homies114524723h_omies
homines123518643homines
hommos13128503hommo_s
hommoses1538153hommoses
homologs1448233homologs
homophobes2246563homophobes
homophones2048383homophones
homos105921783h_omo_s
hondles113614523hondles
hones88144493h_o_nes
hongies112716473hongies
honkies143015143honkies
honorees1148773honorees
honors94816793h_onors
hoochies1639603hoochies
hooded114616743hoo_ded
hoodie105116143hoodie_
hoodier113812973hoodier
hoodiest122413173hoodiest
hoodless12289733hoodless
hoodoo10109983hoodo_o
hoodooed1344963hoodooed
hoods95124083h_o_ods
hooey114926603h_o_oey
hooeys125512313hoo_eys
hoofed134614893hoo_fed
hoofer124014953hoo_fer
hoofers134513323hoofers
hoofless14258013hoofless
hoofs115721043h_o_ofs
hookahs17446653hookahs
hookas135312493hoo_kas
hooked145320553hoo_ked
hooker134820173hoo_ker
hookers144916513hookers
hookey164713933hoo_key
hookeys17448953hookeys
hookier143811673hookier
hookiest152712103hookiest
hookless151238363hookless
hooklet142510813hooklet
hooklets15217203hooklets
hooknose1544273hooknose
hooknoses1644353hooknoses
hooks125027123h_o_oks
hookups1633263hookups
hoolie93217783hoolie_
hoop96129983hoop___
hooping133615703hooping
hoopla1147633hoop_la
hoopster1335543hoopster
hoopsters1445683hoopsters
hoorahs13399603hoorahs
hoorays13418373hoorays
hoosgows1542913hoosgows
hootches1656973hootches
hooted104422663hoo_ted
hooter94123933hoo_ter
hooters104520473hooters
hootier104915353hootier
hootiest113115643hootiest
hoots84830253h_o_ots
hooved134713123hoo_ved
hoover124314433hoo_ver
hoovers134312703hoovers
hope96639673h_op_e_
hoped115628183h_op_ed
hoper105829143h_op_er
hopers114222973h_opers
hopped144318113h_opped
hopper134218483h_opper
hoppers143115143hoppers
hoppier143110703hoppier
hoppiest152610723hoppiest
hopple132910483hopple_
hoppled15338083hoppled
hops97942633h_op__s
hordes104921633h_ordes
hormones13311163hormones
horologes1348313horologes
horrors1078693horrors
horses94729343h_orses
horstes104516113horstes
hoses85443173h_o_ses
hospices1587633hospices
hotboxes2045063hotboxes
hotches153814363hotches
hotdogs1234453hotdogs
hotpress1344303hotpress
hotrods1148283hotrods
hotspots1344843hotspots
hotties103016963hotties
houses96032273h_ouses
howdies142911953howdies
howes114730263h_o_wes
hoyles12315013h_oyles
hulloes104113923hulloes
hypes135818673h_yp_es
hypoed1547923h_ypoed
hypos1312014743h_ypo_s
isopods1045573isopods
joypops2162603joypops
koodoos12116393koodoos
kopjes1935363_kopjes
koppies153210013koppies
locoes85516583_locoes
loobies93814103loobies
looies65025833loo_ies
loonies73919543loonies
looped95217173loop_ed
looper83817113loop_er
loopers93914033loopers
loopholes1448893loopholes
loopier93711193loopier
loopiest103011313loopiest
loops75723963loop__s
looses67328243loo_ses
lopes76437343_lop_es
loupes84918053loup_es
mojoes15399523_mojoes
mongoes103415713mongoes
monopodes1447723monopodes
monopods1347973monopods
monopoles1349573monopoles
mooches143714453mooches
mopes95134983_mop_es
mopokes1536693mopokes
mottoes93412193mottoes
myopes13419963myop_es
myopies14309723myopies
noodges9317703noodges
noodles83513193noodles
noogies82814583noogies
nookies113414963nookies
nooses65623643noo_ses
oboes75717713__oboes
oodles73517183_oodles
oops65232673_oop__s
oospores1049533oospores
oozes145418713_oo_zes
opes65942613__op_es
oppose1039193_oppose
opposes1149243_opposes
ouphes113614633_ouphes
peoples11312213peoples
pompoms1535333pompoms
pompons1338553pompons
pompous1338063pompous
pooches143214163pooches
poodles103013513poodles
pooped113915943poop_ed
poops94422413poop__s
pooves113914713poo_ves
popes95933813_pop_es
poppies102816193poppies
popples103011873popples
potpies113116173potpies
propones122516963propones
propose112714843propose
proposes122515973proposes
roofies103014413roofies
rookies113917103rookies
roomies93017243roomies
rooses65526233roo_ses
rootles73215633rootles
ropes75940063_rop_es
roscoes9310923roscoes
scopes104719593scop_es
shoppes143411393shoppes
slopes84820453slop_es
soothes103917113soothes
sopors85215203_sopors
stopes84525893stop_es
thorpes125010353thorp_es
toonies73719883toonies
tootles72915603tootles
tootses72910773tootses
topees85519703_topees
topes76941763_top_es
tophes115218423_tophes
topos75726393_topo_s
topples113111653topples
torpors939383torpors
toupees938513toupees
tropes84824353trop_es
uropods1035873uropods
voodoos1196343voodoos
whooped16326933whoop_ed
whoopee15287513whoop_ee
whooper15297153whoop_er
whoopers16286263whoopers
whoopie15295933whoopie_
whooplas1644003whooplas
whoops14487863whoop__s
whooshes1734423whooshes
woodies113517153woodies
woolies104117363woolies
woops104917523woop__s
woopsed1344733woopsed
wooshes13169883wooshes
yobboes1445583yobboes
youpons12265983youpons
zoonoses1746203zoonoses
zoophobes2545283zoophobes
zoospores2046213zoospores

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340273406.70319995.1
3Display Results3403400.1103090.9
 (SQL Overall)1786913406.95325699.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.