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
dada6642245(None) 
dad58456171dad_
dadas75819861dadas
dado67126341dado
dads67442781dads
data56026651data
nada58022911nada
aa219179952_a_a
aba512850952_aba
ad311975042_ad_
add510132372_add
addax1435992addax
adds67622462adds
ado49146882_ado
ads49755742_ads
adz1312332872_adz
aga410447232_aga
aha611246642_aha
ala312463602_ala
ama510853302_ama
ana39559832_ana
ava610139322_ava
awa611939672_awa
baa510650422ba_a
baba88828352baba
bad67763162bad_
bade75140892bade
bads77048872bads
banda85223112banda
caca85528082caca
cad67456372cad_
cade76443922cade
cadi75732192cadi
cads76144532cads
casa65630862casa
coda77029352coda
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
damar84117742damar
dame77140312dame
damn75724322damn
damp96228842damp
dams77444372dams
dan46859672da_n
dandy104416702dandy
dang65131552dang
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
did56850532did_
dido66528212dido
didy99121522didy
dita56032532dita
diva85920892diva
dodo66024922dodo
dona55529632dona
dopa77220902dopa
drama85117422drama
duad66521412duad_
duads76515342duads
dud56737602dud_
dude65629672dude
duds65530152duds
duma75524452duma
dura55232112dura
dyad96415452dyad_
dyads10549972dyads
fad77452422fad_
fade85736352fade
fado87226472fado
fads86939882fads
fava106820262fava
gad57556662gad_
gadi66329732gadi
gads67843392gads
gaga66625552gaga
gala55635162gala
gama77035522gama
garda7316762garda
had77658772had_
hadal95518122hadal
hade85440202hade
hadj155818682hadj
haha107821062haha
jade125325452jade
java147316642java
kadi96224842kadi
kaka76518692kaka
kana85928542kana
kapa106021302kapa
kata85626032kata
kava115819712kava
lad48165712lad_
lade56345992lade
lads56549142lads
lady86527162lady
lama66635292lama
lava76725422lava
mad68958722mad_
madam10316222madam
made75440252made
mads76845382mads
mama86231592mama
mana65341962mana
mara67444572mara
masa65034722masa
maya95824592maya
nadas66320812nadas
nala46930392nala
nana46632902nana
napa66927262napa
oda48133052_oda
paca85132242paca
pad68057332pad_
padi76331792padi
pads76742962pads
panda85022612panda
papa85827142papa
para65242172para
qadi145621112qadi
rad47662012rad_
radar61316722radar
rads56046612rads
raga55930812raga
raia46638382raia
raja117918682raja
raya75224822raya
sad47459212sad_
sade55544482sade
sadi55834652sadi
saga55331172saga
soda56329392soda
tad47959832tad_
tads57143952tads
taka87623592taka
tala45938052tala
tapa65129152tapa
taxa116820102taxa
vanda94515922vanda
vara75530882vara
vasa76522972vasa
wad77053902wad_
wade85237072wade
wadi86228182wadi
wads87343152wads
wady115325002wady

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.330541487.9
2DLD Change Limit298721920.96630923.4
3Display Results1921920.0503840.0
 (SQL Overall)1786911921.346132757.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.