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 “dodos” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

179 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
dodos7581939(None) 
dados75522431dados
didos76820811didos
dodo66024911dodo_
dodoes85716101dodoes
dojos135111791dojos
adobos9438452adobos
ados57633512_ados
bodes84935102bodes
bods76244712bod_s
bohos105618252bohos
bolos75531372bolos
boos67955032bo_os
boyos105418282boyos
bozos165216862bozos
cocos95624692cocos
codas84724242codas
codes86247292codes
codon86522852codon
codons96119462codons
cods76848102cod_s
cohos105921852cohos
condos94322332condos
coos67456492co_os
dadas75819862dadas
dado67126332dado_
dadoes85616532dadoes
dads67442772dad_s
dagos76419442dagos
datos65222782datos
decos85522122decos
demos86022992demos
dido66528202dido_
didoes85716962didoes
dildos8179302dildos
dinos65428062dinos
diodes83915782diodes
doats65224882doats
dobros93910232dobros
docks126022312docks
docs75631152do_cs
dodge86618132dodge
dodges96119082dodges
dodgy116611462dodgy
dodoism1135892dodoism
doers65225712doers
does56554472do_es
doffs125614332doffs
dogdom1186362dogdom
dogdoms1295422dogdoms
doges75630162doges
dogs66440152do_gs
doits66223672doits
dojo126016142dojo_
doles67843752doles
dolls66126922dolls
dolor67617962dolor
dolors75115312dolors
dols56943052do_ls
dolts65626312dolts
domes85735562domes
doms76239572do_ms
donas65926472donas
dongs76525812dongs
donor64418192donor
donors75115792donors
dons56048702do_ns
doodoo8108892doodoo
doodoos9107622doodoos
doody105517912doody
doom76430072do_om
dooms85321342dooms
door56928512do_or
doors65022132doors
dopas85019062dopas
dopes84935042dopes
dorados938202dorados
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602do_rs
dos48062312__dos
doses65938502doses
doss56235042do_ss
dotes65836692dotes
dots55647662do_ts
doums85417642doums
doves94728152doves
downs94918572downs
dows85941052do_ws
dozes155226302dozes
dudes75424372dudes
duds65530142dud_s
duomos936822duomos
duos56728132d_uos
duros65422692duros
eidos65817752eidos
exodos1435942exodos
fados95620732fados
fidos95819052fidos
foods95924162foods
gobos86219382gobos
gods65438042god_s
gogos77516522gogos
goods75124482goods
goos57644912go_os
hobos106321352hobos
hods87239862hod_s
homos105921792homos
hoods95124082hoods
iodous7311502iodous
judos134711732judos
kobos115616892kobos
kolos94921212kolos
kotos95717702kotos
kudos105011252kudos
lidos65219882lidos
lobos75921842lobos
locos75822602locos
lodes66436912lodes
logos67225332logos
loos49051122lo_os
lotos54724632lotos
modes85537412modes
mods77945052mod_s
modus85417202modus
mojos145314462mojos
mondos95217332mondos
monos75930862monos
moods85224622moods
moos66051302mo_os
mozos165516332mozos
nodes64633492nodes
nodose738882nodose
nodous7711332nodous
nods55838222nod_s
nodus66315992nodus
nolos54423352nolos
nomos75919742nomos
odas57230262_odas
odds68919922_odds
odes57243242_odes
odor55718092_odor
odors64514282_odors
ods47546212_od_s
onos46229002_onos
ordos65216202ordos
pods76540152pod_s
polos76129912polos
pomos95321582pomos
poods85124752poods
poos65949112po_os
redos65126762redos
rodeos75314502rodeos
rodes614039082rodes
rods56442062rod_s
rondos74616732rondos
roods65125282roods
rotos56027882rotos
sodas64123542sodas
sodom8814912sodom
sodoms989672sodoms
sods54940212sod_s
solos54830792solos
tods56141842tod_s
tondos75115922tondos
topos75726392topos
toros54336192toros
toyos87519142toyos
udos56619902_udos
updos8389512updos
vodou939342vodou
vodous1038602vodous
woods95723032woods
woos76238802wo_os
yodhs12669012yodhs
yods86531182yod_s
zoos135828802zo_os

Search took 9 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 Filter178691538000.890200776.4
2DLD Change Limit538001797.0807598.9
3Display Results1791790.1401278.6
 (SQL Overall)1786911798.11022033.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.