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

175 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
dado6712633(None) 
ado49146871_ado
dad58456161dad_
dada66422441dada
dados75522431dados
dads67442771dads
dago65725081dago
dato56129941dato
dido66528191dido
dodo66024911dodo
fado87226461fado
abo59045962_abo
ad311975032_ad_
add510132362_add
adds67622452adds
ados57633512_ados
ads49755732_ads
adz1312332862_adz
ago48845522_ago
apo511142122_apo
avo68936232_avo
azo128233392_azo
bad67763152bad_
bade75140882bade
bads77048862bads
cad67456362cad_
cade76443912cade
cadi75732172cadi
cads76144522cads
calo64936442calo
camo85731752camo
capo85829212capo
dab67455562da_b
dabs77139402dabs
dace76934922dace
dadas75819862dadas
daddy116212562daddy
dadoed9449892dadoed
dadoes85616532dadoes
daff115229682daff
daft85537252daft
dag57753002da_g
dagos76419442dagos
dags66642592dags
dah78148982da_h
dahl87019222dahl
dahs88231812dahs
dais57040702dais
dak86340692da_k
daks97130602daks
dal47554952da_l
dale55643982dale
dals57145122dals
dam67457042da_m
dame77140312dame
damn75724322damn
damp96228842damp
dams77444372dams
dan46859662da_n
dandy104416702dandy
dang65131532dang
danio6319782danio
dank95828232dank
dans56748142dans
dap66652452da_p
daps77239162daps
darb76033532darb
dare55848862dare
dark95133212dark
darn56434622darn
dart55857872dart
dash87031632dash
data56026652data
date56443322date
datos65222782datos
datto65416422datto
daub77423442daub
daut56443562daut
davy116015522davy
daw77148362da_w
dawk126117282dawk
dawn85624202dawn
daws86638242daws
dawt85435942dawt
day76254112da_y
days87637132days
daze147327232daze
dead65434242dead_
deads75726912deads
deco76125972deco
demo77427552demo
diazo15310032diazo
did56850512did_
didos76820812didos
didy99121502didy
dildo71911772dildo
dino56036752dino
do310155252__do
dodos75819392dodos
dojo126016142dojo
dorado838812dorado
duad66521412duad_
duads76515342duads
dud56737592dud_
dude65629662dude
duds65530142duds
duo48536142d_uo
duro56228022duro
dyad96415452dyad_
dyads10549972dyads
eddo63411802eddo
fad77452412fad_
fade85736342fade
fados95620732fados
fads86939872fads
fano75831682fano
faro76136922faro
fido87726392fido
gad57556652gad_
gadi66329722gadi
gadjo1436912gadjo
gads67843382gads
had77658762had_
hade85440192hade
hadj155818672hadj
halo76437322halo
hao67251122ha_o
jade125325442jade
jato115822682jato
judo125315302judo
kadi96224822kadi
kayo116417552kayo
kudo96115102kudo
lad48165702lad_
lade56345982lade
lads56549132lads
lady86527152lady
lido56028152lido
mad68958702mad_
made75440232made
mads76845362mads
mako105622352mako
mano66536792mano
mayo96524292mayo
nada58022902nada
ordo54622352ordo
pad68057322pad_
padi76331782padi
pads76742952pads
qadi145621102qadi
rad47662002rad_
radio64922492radio
radon64620502radon
rads56046602rads
rato45436972rato
redo56029362redo
sad47459202sad_
sade55544472sade
sadi55834642sadi
sago56332672sago
spado83713702spado
taco67031352taco
tad47959822tad_
tads57143942tads
tao38358952ta_o
tardo65321102tardo
taro46846912taro
udo49027302_udo
undo55620152undo
updo76712882updo
wad77053892wad_
wade85237062wade
wadi86228172wadi
wads87343142wads
wady115324992wady

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298721750.95331345.2
3Display Results1751750.0463804.3
 (SQL Overall)1786911751.079165608.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.