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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
amnestic124705(None) 
amnesic1137181amnes_ic
agnostic1146712agnostic
agrestic1147922agrestic
amnesia938292amnes_ia
amnesiac1265072amnesiac
amnesics1255282amnes_ics
amnestied1263632amnestied
amnesties1166872amnesties
amnesty1244822amnest_y
amniotic1246402amniotic
anamnestic1453602anamnestic
asbestic1245382asbestic
majestic1944912majestic
acetic10314503a_ce_tic
acoustic1246443acoustic
acrostic1239943acrostic
agenetic1138203agenetic
agnatic10310973agn_atic
agnostics1244463agnostics
agonistic1246683agonistic
akinetic1455953akine_tic
aloetic9313183aloe_tic
amebic1239113am_e_bic
amentia9310153am_entia
amitotic1247013amitotic
amnesiacs1353243amnesiacs
amnesias1047833amnesias
amnestying1642033amnestying
amnic95516243amn___ic
amnionic1245603amnionic
amoebic1346153amoe_bic
amoristic1347993amoristic
anapestic1346313anapestic
andesitic1245243andesitic
anelastic1147043a_nelastic
anemic102713693a_ne_mic
anergic1048113a_nergic
anestri746933a_nestri
anisic8313793a_nis_ic
anosmic1137783a_nosmic
antic75728863a_n__tic
aoristic10311163aoristic
aphetic142912853aphe_tic
aplastic1249243aplastic
apneic1078623apne__ic
argentic1149023argentic
artistic10310893artistic
ascetic11310063asce_tic
aseptic1137373a_septic
atheistic1447353atheistic
atresic9310003atres_ic
atretic9313923atre_tic
autistic10310103autistic
auxetic1637143auxe_tic
cuneatic1245853cuneatic
domestic1347813domestic
dynastic1445853dynastic
emetic10614453em_e_tic
faunistic1444473faunistic
gametic12310003gam_e_tic
genetic101211783gene_tic
gestic9312773__gestic
gnostic1038433_gnostic
gymnastic1742553gymnastic
kinesic13257023kines_ic
kinetic13209173kine_tic
limnetic1255583limne_tic
magnesic1345753magnes_ic
magnetic1349233magne_tic
maieutic1243873maieutic
mannitic1248013mannitic
mantic104120903man__tic
mastic103119173_m_astic
mesic93617863_m_es_ic
monastic1249863monastic
monistic12311303monistic
mystic132711643_m_ystic
nastic82915973__nastic
neustic937943__neustic
smectic1336613sm_ectic
synectic1546333synectic
telestic10118953telestic
tenesmic1244303tenesmic
tonetic9313433tone_tic
tungstic1143843tungstic

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.423422437.4
2DLD Change Limit146162867.23320207.7
3Display Results86860.0501720.0
 (SQL Overall)178691867.70623188.6
 
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.