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

187 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
hoodoo1010998(None) 
doodoo8108891doodoo
hoodoos11109291hoodoos
hoopoo1198751hoopoo
koodoo11107771koodoo
voodoo10127531voodoo
booboo1039462booboo
boocoo1039002boocoo
boohoo1148832boohoo
bookoo1248342bookoo
coocoo1069692coocoo
doodoos9107622doodoos
holloo94415252holloo
hood85132332hood__
hooded114616742hooded
hoodie105116142hoodie
hoodooed1344962hoodooed
hoods95124082hood_s
hoody124919722hood_y
hoopoe11911232hoopoe
hoopoos1298542hoopoos
hotdog1134802hotdog
koodoos12116392koodoos
voodoos1196342voodoos
booboos1138143booboos
boocoos1137753boocoos
boodle93215033boodle
boody115420403bood_y
boohoos1237993boohoos
bookoos1337503bookoos
codon86522853_codon
condo85322593cond_o
condom114215363condom
condor94616973condor
condos94322333condos
cordon95017293cordon
coydog1335133coydog
dodo66024913_dod_o
dodos75819393_dodos
dogdom1186363dogdom
doodad936423doodad
doodle83212853doodle
doody105517913dood_y
doowop1283853doowop
exodoi1443973exodoi
exodos1435943exodos
fogdog1234223fogdog
food86830573food__
foodie104413843foodie
foods95924163food_s
fordo97218653ford_o
good66531803good__
goodby13406283goodby
goodie83613993goodie
goodly11419303goodly
goods75124483good_s
goody105620393good_y
googol835843googol
hagdon1188283hagdon
halloo95118973halloo
hobnob1335133hobnob
hobo97026083h_o_bo
hobos106321353h_obos
hod76852463h_od__
hodad10311353h_odad
hodden113811453hodden
hoddin11369943hoddin
hods87239863h_od_s
hoed87837983hoed__
hoedown14125753hoedown
hoiden103612333hoiden
hold86235063hold__
holden104113953holden
holder104619653holder
holdout11510903holdout
holds94623243hold_s
holdup1245183holdup
hollo84822163h_ollo
holloa94914823holloa
holloos104013583holloos
hollos95320633hollos
hollow124212663hollow
hommos13128503hommos
homo96126473h_o_mo
homolog1346963homolog
homos105921783h_omos
honcho14389383honcho
honda9414983hond_a
hondas10313353hondas
hondle103914523hondle
honor85718623h_onor
hooch135813703hoo_ch
hoodier113812973hoodier
hoodies113419833hoodies
hooding123815203hooding
hoodlum1343823hoodlum
hoodmold1542723hoodmold
hoodooing14103933hoodooing
hoodooism1553273hoodooism
hooey114926603hoo_ey
hooeys125512313hooeys
hoof106036583h_o_of
hoofed134614893hoofed
hoofer124014953hoofer
hoofs115721043hoo_fs
hook116133283h_o_ok
hooka125513903hoo_ka
hookah16488243hookah
hookas135312493hookas
hooked145320553hooked
hooker134820173hooker
hookey164713933hookey
hooks125027123hoo_ks
hookup1534423hookup
hooky155220263hoo_ky
hoolie93217783hoolie
hooly115022223hoo_ly
hoop96129983h_o_op
hooped125518183hooped
hooper114518313hooper
hoopla1147633hoopla
hoopoes121212483hoopoes
hoops105621073hoo_ps
hoorah124411113hoorah
hooray123011373hooray
hoosgow1442763hoosgow
hoot75752103h_o_ot
hootch14386413hootch
hooted104422663hooted
hooter94123933hooter
hoots84830253hoo_ts
hooty115022443hoo_ty
hooved134713123hooved
hoover124314433hoover
hooves124815483hooves
horde94623053hord_e
horded115420483horded
hordes104921633hordes
horror988723horror
hotbox1835703hotbox
hotdogs1234453hotdogs
hotfoot1347053hotfoot
hotrod1048803hotrod
houdah1335173houdah
howdah1634723howdah
howdie13349733howdie
howdy155711413howd_y
hoyden13328933hoyden
hulloo94511733hulloo
hydro12259423h_ydro
mondo85721233mond_o
mondos95217333mondos
mood76332063mood__
moods85224623mood_s
moody115017493mood_y
noodge8337583noodge
noodle73212543noodle
odor55718093__odor
ordo54622353_ord_o
ordos65216203_ordos
pood75934323pood__
poodle93112043poodle
poods85124753pood_s
roadeo7510323roadeo
rodeo65921093_rodeo
rondo65218373rond_o
rondos74616733rondos
rood56733003rood__
roods65125283rood_s
skidoo1136093skidoo
sodom8814913_sodom
soldo67116563sold_o
sordor7310223sordor
tondo69718683tond_o
tondos75115923tondos
vodou939343_vodou
voodooed1343293voodooed
voudon1035873voudon
wood85329383wood__
woodbox2043693woodbox
wooded114213683wooded
wooden103610303wooden
woodie103513613woodie
woodlot1147023woodlot
woods95723033wood_s
woodsy13505923woodsy
woody125116883wood_y

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.390458182.1
2DLD Change Limit1127161875.33021147.5
3Display Results1871870.0632968.3
 (SQL Overall)1786911875.78330899.4
 
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.