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

104 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
anaemia95980(None) 
anaemias1069201anaemias
anaemic1149901anaemic
anemia82613571an_emia
academia1345112academia
analemma12113892analemma
analgia898362analgia
anemias92512142an_emias
anemic102713692an_emic
anosmia946642anosmia
anoxemia1754772anoxemia
anthemia1349192anthemia
pyaemia1445732pyaemia
uraemia946502uraemia
abasia8712953aba_sia
abelia83114403a_belia
acacia10311353aca_cia
academias1444793academias
academic1544723academic
acapnia1145913acapnia
acedia9310393a_cedia
acidemia1344783acidemia
acromia1139963acromia
adynamia1443123adyna_mia
aecia73819283__aecia
agama85815583aga_m_a
agamic113110563aga_mic
agamid103710693aga_mid
alameda1035493alameda
alexia132910463a_lexia
amia66836903__a_mia
amnesia938293amnesia
anadem939183anadem__
anadems1036143anadem_s
anaerobia1184113anaerobia
analecta1045733analecta
analemmas13103583analemmas
analgesia10174413analgesia
analgias9107803analgias
anathema1344583anathem_a
anatomic1258683anatomic
anergia847363anergia
angaria8311583angaria
angelic1039623angelic
angelica1145893angelica
anima74620073an_im_a
animi74016663an_imi_
animis84615943an_imis
annelid838733annelid
anomic102516303an_omic
anomie83215963an_omie
anopia83412393an_opia
anopsia9258443anopsia
anorexia1544913anorexia
anosmias1056083anosmias
anosmic1137783anosmic
anoxemias1844543anoxemias
anoxemic1945593anoxemic
anoxia133510023an_oxia
antefix1745053antefix
antefixa1843253antefixa
antenna746383antenna
anthelia1149113anthelia
anthemic15410323anthemic
antianemia1253733antianemia
anuria6313123an_uria
aphelia1249423aphelia
apteria9312913apteria
aramid93315613ara_mid
asteria7316183asteria
ataxia13179593ata_xia
atresia7310223atresia
azotemia19104173azotemia
bohemia1446363bohemia
coremia11310363coremia
encaenia1044303encaenia
encomia1147983encomia
endemial1146583endemial
endemic1237893endemic
enema7612743en_em_a
gynaecia1442363gynaecia
haemic133210083_haemic
haemin113412663_haemin
kalmia1238893_kalmia
lamia75324323_la_mia
mazaedia2043493mazaedia
naevi867873_naevi_
nema65522523_n_em_a
panama104213353pana_m_a
pandemic1545543pandemic
pyaemias1545063pyaemias
pyaemic1645873pyaemic
pyemia1337553_pyemia
santeria8311653santeria
sapraemia1353353sapraemia
sapremia1245203sapremia
taenia6313193_taenia
toxaemia1743063toxaemia
toxemia1644873toxemia
uraemias1046043uraemias
uraemic1156543uraemic
uremia82910893_uremia
viremia1246083viremia
zamia165115213_za_mia

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.440406115.9
2DLD Change Limit1340271046.42020876.5
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.90625874.7
 
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.