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

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

156 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
aggada95520(None) 
aggadah1362831aggadah
aggadas1054981aggadas
haggada1353621haggada
agama85815572a_gama
agenda837252agenda
aggadahs1462242aggadahs
aggadic1254782aggadic
aggadot1045132aggadot
aggrade1035632aggrade
argala74712662argala
armada938782armada
haggadah1762572haggadah
haggadas1463612haggadas
abaca95118043a_baca
abaka114313823a_baka
abaya104413173a_baya
abrade9313053abrade
aga410447233a_g__a
again65218113a_gain
agamas97413443a_gamas
agapae9388043a_gapae
agapai9456843a_gapai
agape85614843a_gape
agar58726413a_ga_r
agars66120643a_gars
agas55938843a_ga_s
agate66525143a_gate
agave95314033a_gave
agaze156113663a_gaze
aged67334253a_ged_
agendas936933agendas
aggadoth1452003aggadoth
agger76420893agg_er
aggers85817793aggers
aggie73415013agg_ie
aggies83515513aggies
aggraded1244183aggraded
aggrades1135853aggrades
aggro738003agg_ro
aggros836543aggros
agha87417303a_g_ha
aghas97014873agha_s
aghast105711363aghast
agita6315423a_gita
aglare7312423aglare
agma77623263a_g_ma
agmas85919873agma_s
agnail739523agnail
agnate73314873agnate
agora6914333a_gora
agrafe1038093agrafe
agrapha1345133agrapha
agria65517143a_gria
ahead96817053ahead_
albata839333albata
alcade91111513alcade
alga57927603alg__a
algae65319623alga_e
algal66518213alga_l
algas65624933alga_s
algid75415573algid_
alpaca1047383alpaca
anga56831353ang__a
angaria8311553angaria
angary10311323angary
angas65827983anga_s
angina7413133angina
angora71111573angora
arcade91013643arcade
arcadia1039703arcadia
arcana8912583arcana
argal65023383arga_l
argalas84011083argalas
argali75013743argali
argals75517703argals
armadas1038173armadas
asana5315483a_sana
asrama839193asrama
aubade939223aubade
audad71511383audad_
audads8167103audads
avgas96912133avga_s
baggage1235633baggage
bagged114519903bagged_
cicada1136413cicada
dada66422443__dada
dagga839543dagg__a
daggas937973dagga_s
egad64215413_egad_
egads74610923_egads
eggar7458883egga_r
eggars8398973eggars
egged85114383egged_
fagged124717703fagged_
fanegada1341613fanegada
gad57556653__gad_
gadi66329723__gadi
gads67843383__gads
gaga66625553__gaga
gagaku1243813gagaku
gaged85522313gaged_
gagged104817153gagged_
gala55635163__gala
gama77035513__gama
garda7316763_garda
gelada837623gelada
glad65624013_glad_
glade75121963_glade
glads75620613_glads
glady105413943_glady
goad66830983_goad_
goads77022853_goads
grad66829863_grad_
grade75126093_grade
grads75625753_grads
grama85620283_grama
grana65722093_grana
guava938583_guava
haggadahs1872063haggadahs
haggadic1643053haggadic
haggadot1444033haggadot
haggard13377183haggard
haggards14366763haggards
hagged124317703hagged_
hamada1239913hamada
hammada1545083hammada
igged86012763igged_
iguana735803iguana
jaggary19304863jaggary
jagged164115353jagged_
laggard10347623laggard
laggards11307053laggards
lagged95520133lagged_
lambada1245643lambada
magmata1237463magmata
megara9310093megara
nada58022903__nada
nagana748943nagana
nagged93916053nagged_
organa789213organa
pagoda10487873pagoda
panada94113053panada
posada937163posada
ragged94620263ragged_
raggedy13334663raggedy
ramada9310183ramada
saggar84010853sagga_r
saggard10358953saggard
saggards11397493saggards
saggars93610683saggars
sagged94120003sagged_
taggant9310213taggant
tagged93418123tagged_
wagged124616123wagged_
zagged183612513zagged_

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161565.73319660.9
3Display Results1561560.0463391.3
 (SQL Overall)1786911565.92230174.1
 
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.