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

120 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
andantes931085(None) 
andante8311271andante_
anankes1138762an_ankes
annates72415422anna_tes
atlantes838552atlantes
infantes11249632infantes
mandates11314092manda_tes
abates85825033a_ba_tes
abidances1445593abidances
ablates92416903abla_tes
abundances1543313abundances
adages8412953a_da_ges
adapted1135843a_dapted
adapter1036173a_dapter
adapters1136103a_dapters
adapts9107813a_dapt_s
addaxes1634573adda_xes
adnate72913483adna_te_
advances1445613advances
aerates74627493aera_tes
agates76121343a_ga_tes
agnates82813193agna_tes
airdates939723airda_tes
alants67722023a_lant_s
alates64833963a_la_tes
alkanes113812933alkan_es
alkanets12366233alkanets
allanites949803allanites
amiantus1044383amiantus
analytes11169203analytes
ananke1038283an_anke_
anattos7138453an_attos
ancones93116343ancon_es
andantini1044563andantini
andantino1044893andantino
andantinos1152243andantinos
andesites1048553andesites
andesytes1343583andesytes
andradites1244773andradites
angaries9314393angaries
animates101316423animates
anlaces92313733anla_ces
anlages82414113anla_ges
anlases72514903anla_ses
annattos8133723annattos
anodynes1244443anodyn_es
anointed938343anointed
anointer837823anointer
anointers937003anointers
anoints7311063anoint_s
anolytes11169213anolytes
ansate64517863ansa_te_
ansated84214003ansa_ted
antedates1048613anteda_tes
antes56334323___antes
aphanites1448273aphanites
arranges939413arranges
aviates10313063avia_tes
bandages12310633banda_ges
bandanas11178573bandan_as
bandannas12163283bandannas
bandmates1447923bandmates
caudates11310263cauda_tes
dances95120653__dances
dates65639153__da_tes
enates64026433en_a_tes
endanger1045853endanger
endangers1144943endangers
endashes12217453endashes
endites83717063end_ites
endnotes945943endnotes
enhances1339293enhances
ententes8312773ententes
fandangos1442293fandangos
fondants1246203fondant_s
handaxes1938403handa_xes
inanes62519803in_an_es
incanted11259543incanted
incants92012803incant_s
indagates1146573indagates
indenes82916253inden_es
indented101811733indented
indenter92311443indenter
indenters102710033indenters
indents83114663indent_s
indites83618983ind_ites
infantas11246003infantas
infante101910883infante_
infants102210773infant_s
ingates82716913inga_tes
inmates92715783inma_tes
iodates8312903ioda_tes
lindanes939173lindan_es
mandate10315573manda_te_
mandated12310293manda_ted
manganates1345953manganates
manganites1347033manganites
mantes84430783__mantes
nances83618643_n_ances
nates55238333_n_a_tes
nidates8311893nida_tes
nondances1247803nondances
nuances938523_nuances
pandanus1136433pandan_us
pandanuses1343363pandanuses
pedants10310113pedant_s
pendants1139093pendant_s
randans8313213randan__s
redates83423873reda_tes
sedates83418043seda_tes
tannates81911953tanna_tes
tanzanites1944003tanzanites
tendances1247573tendances
undated93118463unda_ted
undaunted1145453undaunted
undented102313953undented
undines8716083undin_es
unwanted12249603unwanted
updates10329793upda_tes
vanadates1345133vanadates

Search took 8 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621207.40319743.6
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.90222613.4
 
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.