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

133 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
dados7552243(None) 
ados57633511_ados
dadas75819861dadas
dado67126331dado_
dadoes85616531dadoes
dads67442771dad_s
dagos76419441dagos
datos65222781datos
didos76820811didos
dodos75819391dodos
fados95620731fados
abos67734412_abos
adds67622452_adds
adios65822862adios
ado49146872_ado_
ads49755732_ad_s
apos65433822_apos
avos77227012_avos
bads77048862bad_s
cades85440732cades
cadis84428502cadis
cads76144522cad_s
calos74431902calos
camos95927612camos
capos94826072capos
dabs77139402da_bs
daces85030682daces
dad58456162dad__
dada66422442dad_a
daddy116212562daddy
dadoed9449902dadoed
daffs125116422daffs
dago65725092dago_
dagoes85714602dagoes
dags66642602da_gs
dahls95012282dahls
dahs88231812da_hs
dais57040702da_is
daks97130602da_ks
dales66439742dales
dals57145122da_ls
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372da_ms
dangs75623202dangs
danios7314602danios
dans56748152da_ns
daps77239162da_ps
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dates65639152dates
dato56129942dato_
dattos74311902dattos
daubs85014562daubs
dauts67822242dauts
dawks135213492dawks
dawns95916592dawns
daws86638242da_ws
dawts97216122dawts
days87637132da_ys
dazes155024142dazes
deads75726912dead_s
decos85522122decos
demos86022992demos
dido66528202dido_
didoes85716962didoes
dildos8179302dildos
dinos65428062dinos
dodo66024912dodo_
dodoes85716102dodoes
dojos135111792dojos
dorados938202dorados
dos48062312__dos
duads76515342duad_s
dudes75424372dudes
duds65530142dud_s
duos56728132d_uos
duros65422692duros
dyads10549972dyad_s
eidos65817752eidos
fades94932862fades
fado87226462fado_
fads86939872fad_s
fanos85926502fanos
faros85532022faros
fidos95819052fidos
gadis74825292gadis
gads67843382gad_s
hades96035112hades
halos85230252halos
jades135222112jades
jatos125116822jatos
judos134711732judos
kadis105921062kadis
kayos127714702kayos
kudos105011252kudos
lades65141272lades
lads56549132lad_s
lidos65219882lidos
mads76845372mad_s
makos116518362makos
manos74933622manos
mayos105521932mayos
nadas66320812nadas
naos47429732na_os
ordos65216202ordos
padis86227142padis
pads76742952pad_s
qadis155917852qadis
radios74018672radios
radon64620502radon
radons74118532radons
rads56046602rad_s
ratos55528762ratos
redos65126762redos
sades65239892sades
sadis64930852sadis
sagos66123872sagos
saros55238062saros
tacos77023552tacos
tads57143942tad_s
taos45541002ta_os
taros55640822taros
udos56619902_udos
updos8389512updos
vadose1037962vadose
wades95634142wades
wadis95223962wadis
wads87343142wad_s

Search took 3 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.326548131.9
2DLD Change Limit538001331.66032409.6
3Display Results1331330.0304433.3
 (SQL Overall)1786911332.01688636.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.