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

105 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
amnesia93829(None) 
amnesiac1265071amnesiac
amnesias1047831amnesias
amnesic1137181amnesic
agenesia945982agenesia
agnosia837642agnosia
akinesia1284072akinesia
amentia9310152amentia
amnesiacs1353242amnesiacs
amnesics1255282amnesics
amnestic1247052amnestic
amnesty1244822amnesty
amnia75918642amn__ia
amusia839172am_usia
anemia82613572a_nemia
atresia7310222atresia
magnesia1145722magnesia
abasia8712953a_basia
abelia83114403a_belia
abrosia939273abrosia
acedia9310393a_cedia
acnes75922623acnes__
acrasia9310033acrasia
adnexa1433673adne_xa
aecia73819283a__ecia
agenesias1045363agenesias
agenesis938043agenesis
agnosias947243agnosias
akinesias1383903akinesias
alexia132910463a_lexia
amberina1247393amberina
ambrosia1245543ambrosia
ameba9312383am_e_ba
amebic1239113am_ebic
amens75624843amens__
amentias1039413amentias
amia66836903am___ia
amies76837693amies__
amines84727983amines__
ammonia1148693ammonia
amnestied1263633amnestied
amnesties1166873amnesties
amnic95516243amn__ic
amnio75218053amn__io
amoeba1035603amoe_ba
amoebic1346153amoebic
amreeta945163amreeta
amusias938583am_usias
anaemia959803anaemia
anamnesis1144023anamnesis
anemias92512143a_nemias
anemic102713693a_nemic
anergia847363a_nergia
anes45255933a_nes__
anisic8313793a_nisic
annelid838733annelid
anopia83412393a_nopia
anopsia9258443anopsia
anosmia946643a_nosmia
anoxia133510023a_noxia
ansa45927773a_n_s_a
anuria6313123a_nuria
aphasia122510873aphasia
aphelia1249423aphelia
aphesis12610513aphesis
aplasia92510803aplasia
apnea73413413apne__a
apneic1078623apne_ic
apteria9312913apteria
ascesis938373ascesis
askesis1136123askesis
astasia7310933astasia
asteria7316183asteria
atresias839473atresias
atresic9310003atresic
auxesis1445443auxesis
babesia1146623babesia
banksia1335943banksia
camelia11510433cam_elia
camisia112810243cam_isia
emesis84712623em_esis
frambesia16142033frambesia
freesia1046323freesia
gambusia1343573gambusia
genesis82510823genesis
gymnasia1442983gymnasia
gynecia1384233gynecia
imperia1148423imperia
kinesic13257023kinesic
kinesis11259593kinesis
magnesian1244713magnesian
magnesias1245693magnesias
magnesic1345753magnesic
manes76648963manes__
mania75634153man__ia
media84721713_m_edia
mensa75318673_mens_a
mesa67025483_m_es_a
mesial84818083_m_esial
mesian84315503_m_esian
mesic93617863_m_esic
paramnesia1454503paramnesia
silesia739083silesia
synesis1039163synesis
tmesis8529793tm_esis

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271056.75019855.9
3Display Results1051050.0303500.0
 (SQL Overall)1786911057.23324705.0
 
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.