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

157 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
doodoo810889(None) 
doodoos9107621doodoos
hoodoo10109981hoodoo
koodoo11107771koodoo
voodoo10127531voodoo
booboo1039462booboo
boocoo1039002boocoo
boohoo1148832boohoo
bookoo1248342bookoo
coocoo1069692coocoo
dodo66024912d_od_o
dodos75819392d_odos
dogdom1186362dogdom
doodad936422doodad
doodle83212852doodle
doody105517912dood_y
doowop1283852doowop
hoodoos11109292hoodoos
hoopoo1198752hoopoo
koodoos12116392koodoos
voodoos1196342voodoos
booboos1138143booboos
boocoos1137753boocoos
boodle93215033boodle
boody115420403bood_y
boohoos1237993boohoos
bookoos1337503bookoos
codon86522853_codon
condo85322593cond_o
condom114215363condom
condor94616973condor
condos94322333condos
cordon95017293cordon
coydog1335133coydog
dado67126333d_ad_o
dados75522433d_ados
deodar837713deodar
dido66528203d_id_o
didos76820813d_idos
dildo71911773dild_o
dildoe8198673dildoe
dildos8179303dildos
diobol936883diobol
diode74716113diod_e
diodes83915783diodes
doblon938013doblon
dobro84412213d_obro
dobros93910233dobros
dobson936593dobson
doctor938993doctor
dodder94712913dodder
dodge86618133d_odge
dodgy116611463d_odgy
dodoes85716103dodoes
dogdoms1295423dogdoms
dogedom1244663dogedom
doggo84410703d_oggo
dogwood1354913dogwood
dojo126016143d_o_jo
dojos135111793d_ojos
dollop9259363dollop
dolor67617963d_olor
doloroso943173doloroso
domino92611493domino
donjon1436463donjon
donor64418193d_onor
doobie94712683doobie
doodads1035093doodads
doodies94218773doodies
doodled10369463doodled
doodler93310153doodler
doodles93614163doodles
doofus1036163doofus
doolee73018953doolee
doolie73916833doolie
dooly94821803doo_ly
doom76430073d_o_om
doomed104113293doomed
dooms85321343doo_ms
doomy116018263doo_my
door56928513d_o_or
doors65022133doo_rs
doowops1363943doowops
doozer163910463doozer
doozie163910653doozie
doozy186813713doo_zy
dorado838813dorado
dorados938203dorados
dowdy136112543dowd_y
dromon939363dromon
drongo836793drongo
drool65416103dro_ol
droop85814823dro_op
duolog835803duolog
duomo839753duo_mo
duomos936823duomos
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
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 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.406440125.6
2DLD Change Limit1127161576.01618736.0
3Display Results1571570.0463413.0
 (SQL Overall)1786911576.46827626.9
 
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.