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

103 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
aggadas105500(None) 
aggada955221aggada_
aggadah1362861aggadah
aggadahs1462261aggadahs
haggadas1463631haggadas
agamas97413452a_gamas
agendas936932agendas
aggadic1254812aggadic
aggadot1045182aggadot
aggrades1135862aggrades
argalas84011092argalas
armadas1038172armadas
haggada1353642haggada_
haggadah1762592haggadah
haggadahs1872082haggadahs
abacas104414723a_bacas
abakas123911743a_bakas
abayas114011703a_bayas
abrades10312073abrades
agama85815583a_gama_
agapae9388043a_gapae
agapai9456863a_gapai
agapes95212413a_gapes
agars66120643a_ga_rs
agas55938843a_g__as
agates76121343a_gates
agaves104611513a_gaves
agenda837253agenda_
aggadoth1452053aggadoth
aggers85817793agg_ers
aggies83515513agg_ies
aggrade1035643aggrad_e
aggraded1244203aggraded
aggress935593aggress
aggros836553agg_ros
aghas97014873a_g_has
agitas7310593a_gitas
agmas85919873a_g_mas
agnails837003agnails
agnates82813193agnates
agoras7613343a_goras
agrafes1137523agrafes
agrias74315393a_grias
albatas938373albatas
alcades101011473alcades
algas65624933alg__as
alpacas1137073alpacas
anabas8314083a_nabas
angarias9310553angarias
angas65827993ang__as
anginas8310953anginas
angoras8811363angoras
arcades101113193arcades
arcadias1149163arcadias
argala74712673argala_
argalis84214193argalis
argals75517713arga_ls
armada938783armada_
asanas6514113a_sanas
asramas938303asramas
aubades1038753aubades
audads8167103audad_s
avgas96912133avg__as
avgases11106313avgases
baggages1335443baggages
cicadas1235993cicadas
dadas75819863__dadas
daggas937973dagg__as
egads74610923_egad_s
eggars8398973egga_rs
fanegadas1441483fanegadas
gadis74825293__gadis
gads67843383__gad_s
gagakus1342883gagakus
galas65731643__galas
gamas85431363__gamas
geladas936313geladas
glades84820343_glades
glads75620613_glad_s
goads77022853_goad_s
grades84926313_grades
grads75625753_grad_s
gradus84411223_gradus
gramas94317203_gramas
guavas1037163_guavas
haggadic1643073haggadic
haggadist1543843haggadist
haggadot1444063haggadot
haggards14366763haggards
hamadas1339673hamadas
hammadas1644793hammadas
iguanas835383iguanas
laggards11307053laggards
lambadas1354873lambadas
nadas66320813__nadas
naganas847983naganas
pagodas11367553pagodas
panadas103312213panadas
posadas1037193posadas
ramadas1039303ramadas
saggards11397493saggards
saggars93610683sagga_rs
taggants1044933taggants

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271035.72023431.3
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.17228951.9
 
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.