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

306 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
hoopoe1191123(None) 
hoopoes121212481hoopoes
hoopoo1198751hoopoo
hoodie105116132hoodie
hoodoo10109982hoodoo
hoolie93217772hoolie
hoop96129982hoop__
hooped125518182hooped
hooper114518312hooper
hoopla1147632hoopla
hoopoos1298542hoopoos
hoops105621072hoop_s
hope96639672h_op_e
hopple132910482hopple
whoopee15287512whoopee
whoopie15295912whoopie
boobie104015293boobie
booboo1039463booboo
boocoo1039003boocoo
boodle93215033boodle
boogie93515993boogie
boohoo1148833boohoo
bookie123516003bookie
bookoo1248343bookoo
bootee84323023bootee
bootie85421153bootie
booze164718913boo_ze
bowpot13410073bowpot
choose115116143choo_se
compo115318573compo_
compone136517193compone
compos124818803compos
compose135716663compose
compote135616463compote
coocoo1069693coocoo
cooee74531023coo_ee
cookie123716043cookie
coolie83821603coolie
coombe124110093coombe
coop87238653coop__
cooped114821603cooped
cooper104221123cooper
coops96229643coop_s
coopt95929853coop_t
coopted123710763coopted
coopts105814583coopts
cootie84223073cootie
cope86847383_cop_e
copse95623923_copse
corpse104013403corpse
coupe96023483coup_e
couple104415963couple
coupon102810993coupon
cowpie133511513cowpie
cowpoke1835103cowpoke
cowpox2035003cowpox
coypou13268403coypou
dhootie1136453dhootie
doobie94712683doobie
doodle83212853doodle
doodoo8108893doodoo
doolee73018953doolee
doolie73916833doolie
doowop1283853doowop
doozie163910643doozie
dope76038893_dop_e
elope75219343elop_e
epopee10312503epopee
foodie104413843foodie
footie94718133footie
footle93914383footle
foozle18369203foozle
gonopore1146373gonopore
goodie83613993goodie
googol835843googol
goonie73615563goonie
goop75829483goop__
goopier103910573goopier
goops86620963goop_s
goopy115816623goop_y
goose65925903goo_se
grope84821613grop_e
haole84820083hao_le
hempie132410563hempie
hippie132811243hippie
hippo12369063hippo_
hippos13408433hippos
hirple11158973hirple
hoagie102310003hoagie
hoarse94411323hoarse
hobble133913433hobble
hobnob1335133hobnob
hobo97026083h_obo_
hoboed124511683h_oboed
hoboes114717443h_oboes
hobos106321353h_obos
hoe67562723h___oe
hognose11117243hognose
hogtie102711763hogtie
hoise85224773h_oise
hoke115935933h_o_ke
hole77553393h_o_le
hollo84822163hollo_
holloa94914823holloa
holloed113812753holloed
holloes103818193holloes
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
holp95727553holp__
holpen11299413holpen
homage121210603homage
hombre13309303hombre
home98042443h_o_me
homie104622523h_omie
hommos13128503hommos
homo96126473h_omo_
homolog1346963homolog
homophobe2146143homophobe
homophone1947833homophone
homos105921783h_omos
hondle103914523hondle
hone77549323h_o_ne
honkie133011663honkie
honor85718623h_onor
honoree10412113honoree
hooch135813703hoo_ch
hooches153812523hooches
hoochie1537783hoochie
hood85132333h_o_od
hooded114616743hooded
hoodier113812973hoodier
hoodies113419833hoodies
hoodooed1344963hoodooed
hoodoos11109293hoodoos
hoods95124083hoo_ds
hoody124919723hoo_dy
hooey114926603hoo_ey
hooeys125512313hooeys
hoof106036583h_o_of
hoofed134614893hoofed
hoofer124014953hoofer
hoofs115721043hoo_fs
hook116133283h_o_ok
hooka125513903hoo_ka
hookah16488243hookah
hookas135312493hookas
hooked145320553hooked
hooker134820173hooker
hookey164713933hookey
hookier143811673hookier
hookies144017443hookies
hooklet142510813hooklet
hooknose1544273hooknose
hooks125027123hoo_ks
hookup1534423hookup
hooky155220263hoo_ky
hooly115022223hoo_ly
hoopers123616483hoopers
hooping133615703hooping
hooplas1239193hooplas
hoopless13279253hoopless
hooplike1736763hooplike
hoopster1335543hoopster
hoorah124411113hoorah
hooray123011373hooray
hoosgow1442763hoosgow
hoot75752093h_o_ot
hootch14386403hootch
hooted104422653hooted
hooter94123923hooter
hootier104915343hootier
hoots84830243hoo_ts
hooty115022433hoo_ty
hooved134713123hooved
hoover124314433hoover
hooves124815483hooves
hop87554593h_op__
hoped115628183h_oped
hoper105829143h_oper
hopes105835643h_opes
hopped144318113hopped
hopper134218483hopper
hoppier143110703hoppier
hoppled15338083hoppled
hopples142810713hopples
hoppy154912353h_oppy
hops97942633h_op_s
horde94623053h_orde
hormone12410503hormone
horologe1248363horologe
horror988723horror
horse86132653h_orse
horste94817413horste
hose76547243h_o_se
hospice14117053hospice
hotbox1835693hotbox
hotdog1134793hotdog
hotrod1048793hotrod
hotspot1247453hotspot
hottie92514363hottie
house89131423h_ouse
hove107132223h_o_ve
howdie13349723howdie
howe106734103h_o_we
hoyle11314413h_oyle
hype125519813h_yp_e
hypo127516353h_ypo_
hypoed1547923h_ypoed
hypos1312014743h_ypos
isopod935913isopod
joypop2063133joypop
koodoo11107773koodoo
kookie9389833kookie
kopje1835273_kopje
koppie14277873koppie
looie55624243loo_ie
loonie64216453loonie
loop67835013loop__
looped95217173looped
looper83817113looper
loophole1358623loophole
loopier93711193loopier
loops75723963loop_s
loopy105316643loop_y
loose56627683loo_se
lope65941923_lop_e
loupe75319513loup_e
mongoe94214983mongoe
monopod1247493monopod
monopode1347643monopode
monopole1249283monopole
moose76327193moo_se
mope86838043_mop_e
mopoke1436633mopoke
myope124010973myop_e
noodge8337573noodge
noodle73212543noodle
noogie73612313noogie
nookie103712433nookie
noose55624063noo_se
nope65934193_nop_e
oboe66822943__oboe
oops65232673_oop_s
oorie53026363_oorie
oospore939013oospore
ooze136420603_oo_ze
ope56845243__op_e
oppose1039193_oppose
ouphe104413263_ouphe
people10310183people
pompom1436493pompom
pompon1238943pompon
poodle93112043poodle
poop86532813poop__
pooped113915943pooped
poops94422413poop_s
poove104514303poo_ve
pope85535613_pop_e
popple92710983popple
potpie103412423potpie
propone112716303propone
propose112714843propose
roofie93411173roofie
rookie103613263rookie
roomie83013873roomie
roose56127093roo_se
rootle63214453rootle
rope65542913_rop_e
roscoe839763roscoe
scope94821483scop_e
shoppe133110313shoppe
slope75823563slop_e
soothe94214843soothe
sopor74016493_sopor
stope74727243stop_e
thorpe113610093thorp_e
toonie63617993toonie
tootle62613813tootle
tope65946383_top_e
topee76029953_topee
tophe106718973_tophe
topo66932403_topo_
topoi76018353_topoi
topos75726393_topos
topple104411323topple
torpor839193torpor
toupee8316133toupee
trope75725803trop_e
uropod937263uropod
voodoo10127533voodoo
whoop134211443whoop__
whooped16326933whooped
whoopees16294823whoopees
whooper15297153whooper
whoopies16267363whoopies
whoopla1542633whoopla
whoops14487863whoop_s
woodie103513613woodie
woolie93514483woolie
woops104917523woop_s
woopsed1344733woopsed
woopses1237883woopses
youpon11366003youpon
zoophobe2445113zoophobe
zoospore1945633zoospore

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.1401276364.3
2DLD Change Limit1127163066.34617761.7
3Display Results3063060.0933290.3
 (SQL Overall)1786913066.57927160.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.