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

192 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
dada6642244(None) 
dad58456161dad_
dadas75819861dadas
dado67126331dado
dads67442771dads
data56026651data
nada58022901nada
aa219179952_a_a
aba512850952_aba
ad311975032_ad_
add510132362_add
addax1435992addax
adds67622452adds
ado49146872_ado
ads49755732_ads
adz1312332862_adz
aga410447232_aga
aha611246642_aha
ala312463602_ala
ama510853302_ama
ana39559832_ana
ava610139322_ava
awa611939672_awa
baa510650422ba_a
baba88828352baba
bad67763152bad_
bade75140882bade
bads77048862bads
banda85223102banda
caca85528082caca
cad67456362cad_
cade76443912cade
cadi75732182cadi
cads76144522cads
casa65630862casa
coda77029342coda
dab67455562da_b
dabs77139402dabs
dace76934922dace
dacha114812572dacha
daddy116212562daddy
dados75522432dados
daedal849082daedal
daff115229682daff
daft85537252daft
dag57753012da_g
dagga839542dagga
dago65725092dago
dags66642602dags
dah78148982da_h
dahl87019222dahl
dahs88231812dahs
dais57040702dais
dak86340692da_k
daks97130602daks
dal47554952da_l
dale55643982dale
dals57145122dals
dam67457042da_m
daman84821162daman
damar84117732damar
dame77140312dame
damn75724322damn
damp96228842damp
dams77444372dams
dan46859672da_n
dandy104416702dandy
dang65131542dang
dank95828242dank
dans56748152dans
dap66652452da_p
daps77239162daps
darb76033532darb
dare55848862dare
dark95133212dark
darn56434622darn
dart55857872dart
dash87031632dash
date56443322date
dato56129942dato
daub77423442daub
daut56443562daut
davy116015522davy
daw77148362da_w
dawk126117282dawk
dawn85624202dawn
daws86638242daws
dawt85435942dawt
day76254112da_y
days87637132days
daze147327232daze
dead65434242dead_
deads75726912deads
dedal75719022dedal
deva85720982deva
did56850512did_
dido66528192dido
didy99121502didy
dita56032522dita
diva85920882diva
dodo66024912dodo
dona55529632dona
dopa77220902dopa
drama85117412drama
duad66521412duad_
duads76515342duads
dud56737592dud_
dude65629662dude
duds65530142duds
duma75524452duma
dura55232112dura
dyad96415452dyad_
dyads10549972dyads
fad77452412fad_
fade85736342fade
fado87226462fado
fads86939872fads
fava106820262fava
gad57556652gad_
gadi66329722gadi
gads67843382gads
gaga66625552gaga
gala55635162gala
gama77035522gama
garda7316762garda
had77658762had_
hadal95518122hadal
hade85440192hade
hadj155818672hadj
haha107821062haha
jade125325442jade
java147316642java
kadi96224822kadi
kaka76518682kaka
kana85928532kana
kapa106021292kapa
kata85626022kata
kava115819702kava
lad48165702lad_
lade56345982lade
lads56549132lads
lady86527152lady
lama66635292lama
lava76725422lava
mad68958712mad_
madam10316222madam
made75440242made
mads76845372mads
mama86231592mama
mana65341962mana
mara67444572mara
masa65034722masa
maya95824592maya
nadas66320812nadas
nala46930392nala
nana46632902nana
napa66927262napa
oda48133042_oda
paca85132242paca
pad68057322pad_
padi76331782padi
pads76742952pads
panda85022612panda
papa85827142papa
para65242172para
qadi145621102qadi
rad47662002rad_
radar61316722radar
rads56046602rads
raga55930812raga
raia46638382raia
raja117918682raja
raya75224822raya
sad47459202sad_
sade55544472sade
sadi55834642sadi
saga55331172saga
soda56329382soda
tad47959822tad_
tads57143942tads
taka87623592taka
tala45938052tala
tapa65129142tapa
taxa116820092taxa
vanda94515922vanda
vara75530882vara
vasa76522972vasa
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.280638182.1
2DLD Change Limit298721920.89033564.0
3Display Results1921920.0464173.9
 (SQL Overall)1786911921.216146949.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.