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

116 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
voodoo1012753(None) 
doodoo8108891doodoo
hoodoo10109981hoodoo
koodoo11107771koodoo
voodoos1196341voodoos
booboo1039462booboo
boocoo1039002boocoo
boohoo1148832boohoo
bookoo1248342bookoo
coocoo1069692coocoo
doodoos9107622doodoos
hoodoos11109292hoodoos
hoopoo1198752hoopoo
koodoos12116392koodoos
vodou939342v_odou
voodooed1343292voodooed
voudon1035872voudon
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
holloo94415253holloo
hood85132333hood__
hooded114616743hooded
hoodie105116143hoodie
hoodooed1344963hoodooed
hoods95124083hood_s
hoody124919723hood_y
hoopoe11911233hoopoe
hoopoos1298543hoopoos
hotdog1134803hotdog
mondo85721233mond_o
mondos95217333mondos
mood76332063mood__
moods85224623mood_s
moody115017493mood_y
noodge8337583noodge
noodle73212543noodle
odor55718093__odor
ordo54622353_ord_o
ordos65216203_ordos
ovolo8339173ovo_lo
ovolos9257203ovolos
pood75934323pood__
poodle93112043poodle
poods85124753pood_s
roadeo7510323roadeo
rodeo65921093_rodeo
rondo65218373rond_o
rondos74616733rondos
rood56733003rood__
roods65125283rood_s
skidoo1136093skidoo
sodom8814913_sodom
soldo67116563sold_o
sordor7310223sordor
tondo69718683tond_o
tondos75115923tondos
vendor10359803vendor
video96014953v_ideo
vocoder1334693vocoder
vodka1354343v_odka
vodoun1036233vodoun
vodous1038603vodous
vodun937223v_odun
void86220563void__
voided114011133voided
voider103611553voider
voids95414673void_s
volvox1933363volvox
vomito11238033vomito
voodooing14112913voodooing
voodooism1551913voodooism
voodooist1353303voodooist
voudons1135323voudons
voudoun1143603voudoun
vroom105312473vro_om
wood85329383wood__
woodbox2043693woodbox
wooded114213683wooded
wooden103610303wooden
woodie103513613woodie
woodlot1147023woodlot
woods95723033wood_s
woodsy13505923woodsy
woody125116883wood_y

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.390458182.1
2DLD Change Limit1127161165.57620214.5
3Display Results1161160.0333515.2
 (SQL Overall)1786911165.99929786.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.