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

229 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
hoopla114763(None) 
hooplas1239191hooplas
whoopla1542631whoopla
holla84918492h_olla
hooka125513902hoo_ka
hooly115022222hoo_ly
hoop96129982hoop__
hooped125518182hooped
hooper114518312hooper
hoopoe11911232hoopoe
hoopoo1198752hoopoo
hoops105621072hoop_s
hopple132910482hopple
moola75117032moo_la
whooplas1644002whooplas
abolla8410193abolla
anopia83412393anopia
bola66035563_bo_la
boodle93215033boodle
boyla102912363_boyla
chola104718033cho_la
cholla113911023cholla
coala77521123_coala
cola66541393_co_la
comply152810383comply
cool66940493coo_l_
coolly114811393coolly
cools75632633coo_ls
cooly105525423coo_ly
coop87238653coop__
cooped114821603cooped
cooper104221123cooper
coops96229643coop_s
coopt95929853coop_t
coopts105814583coopts
copal95621783_copal
coppra12306833coppra
copra98115463_copra
copula102812043copula
corolla938623corolla
couple104415963couple
cowpea1337643cowpea
cupola10317693cupola
dhooly13457143dhoo_ly
dhoora1035653dhoo_ra
dobla84913643_dobla
doodle83212853doodle
dooly94821803doo_ly
dopa77220903_dop_a
doula65717773_doula
fool75330593foo_l_
fools86824203foo_ls
footle93914383footle
foozle18369203foozle
goodly11419303goodly
googly11417883googly
goop75829483goop__
goops86620963goop_s
goopy115816623goop_y
gooral7310463gooral
halala94715093halala
haole84820083hao_le
haply135915063h_aply
hawala12368913hawala
hexapla1943343hexapla
hila76228353h__ila
hiply134113613h_iply
hirple11158973hirple
hobble133913433hobble
hokily16409093hokily
hold86235063h_o_ld
hole77553393h_o_le
holily123612953holily
holk116027943h_o_lk
hollas94616903h_ollas
hollo84822163h_ollo
holloa94914823holloa
holly114824433h_olly
holm95628103h_o_lm
holp95727553h_o_lp
holpen11299413holpen
hols76946293h_o_ls
holt77852583h_o_lt
holy106333433h_o_ly
homely145313173homely
homily144712333homily
homoplasy1944873homoplasy
homopolar1653693homopolar
honda9414983h_onda
hondle103914523hondle
hooch135813703hoo_ch
hood85132333hoo__d
hooded114616743hooded
hoodie105116133hoodie
hoodlum1343813hoodlum
hoodoo10109983hoodoo
hoods95124083hoo_ds
hoody124919723hoo_dy
hooey114926603hoo_ey
hooeys125512313hooeys
hoof106036583hoo__f
hoofed134614893hoofed
hoofer124014953hoofer
hoofs115721043hoo_fs
hook116133283hoo__k
hookah16488243hookah
hookas135312493hookas
hooked145320553hooked
hooker134820173hooker
hookey164713933hookey
hooklet142510813hooklet
hooks125027123hoo_ks
hookup1534423hookup
hooky155220263hoo_ky
hoolie93217773hoolie
hoopers123616483hoopers
hooping133615703hooping
hoopless13279253hoopless
hooplike1736763hooplike
hoopoes121212483hoopoes
hoopoos1298543hoopoos
hoorah124411113hoorah
hooray123011373hooray
hoot75752093hoo__t
hootch14386403hootch
hooted104422653hooted
hooter94123923hooter
hoots84830243hoo_ts
hooty115022433hoo_ty
hooved134713123hooved
hoover124314433hoover
hooves124815483hooves
hop87554593h_op__
hope96639673h_op_e
hoped115628183h_oped
hoper105829143h_oper
hopes105835643h_opes
hopped144318113hopped
hopper134218483hopper
hoppled15338083hoppled
hopples142810713hopples
hoppy154912353h_oppy
hops97942633h_op_s
hora76136553h_o_ra
horal86328673horal_
hosel86024813hosel_
hosels94218603hosels
hosta85917833h_osta
hostly124210863hostly
hotel85520743hotel_
hotels94515503hotels
hotly115815473h_otly
hourly12369623hourly
hovel115017683hovel_
hovels125413333hovels
howl107625693h_owl_
howls116219223h_owls
hoya107418373h_o_ya
hoyle11314413h_oyle
hula74923753h__ula
hyla106716513h__yla
hypha1637383h_ypha
koala95112213_koala
kola85124963_ko_la
koppa13397293_koppa
loofa85912813loo_fa
loop67835013loop__
looped95217173looped
looper83817113looper
loopily1236803loopily
loops75723963loop_s
loopy105316643loop_y
mola66035633_mo_la
mool67533863moo_l_
moolah11409193moo_lah
moolas83615593moo_las
mools76027173moo_ls
morula8710473morula
myopia13318433myopia
nonplay1246683nonplay
noodle73212543noodle
nopal75517103_nopal
olla44821173__olla
oops65232673_oop_s
opal66923523__opal
people10310183people
pepla9312863_pepla
photopia1549703photopia
photoplay1954753photoplay
poodle93112043poodle
pool65835953poo_l_
pools74427703poo_ls
poop86532813poop__
pooped113915943pooped
poops94422413poop_s
poorly1137893poorly
poplar103611113_poplar
poppa8409893_poppa
popple92710983popple
propyla14296633propyla
rootle63214453rootle
scopula1154993scopula
shoofly1634343shoofly
shool84523143shoo_l_
shools94919003shoo_ls
sola45541863_so_la
tola45236333_to_la
tool46735683too_l_
tools55325243too_ls
tootle62613813tootle
topple104411323topple
torula6610393torula
utopia8107883utopia
viola85915543vio_la
voila84813943_voila
whoop134211443whoop__
whooped16326933whooped
whoopee15287513whoopee
whooper15297153whooper
whoopie15295913whoopie
whoops14487863whoop_s
wool76427373woo_l_
woolly12408513woolly
wools84421463woo_ls
wooly114417673woo_ly
woops104917523woop_s
zonula1537223zonula
zooglea1733373zooglea
zoonal1558083zoonal

Search took 6 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 Limit1127162295.39020912.1
3Display Results2292290.0633634.9
 (SQL Overall)1786912295.59331949.0
 
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.