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

81 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
anaemias106920(None) 
anaemia959801anaemia_
anemias92512141an_emias
academias1444792academias
anaemic1149902anaemi_c
analemmas13103582analemmas
analgias9107802analgias
anemia82613572an_emia_
anosmias1056082anosmias
anoxemias1844542anoxemias
pyaemias1545062pyaemias
uraemias1046042uraemias
abasias9711013aba_sias
abelias93213563a_belias
acacias11510403aca_cias
academia1345113academia_
academics1643533academics
academies1444683academies
acapnias1255683acapnias
acedias1039773a_cedias
acidemias1444503acidemias
adynamias1543193adyna_mias
agamas97413453aga_m_as
agamids11317013aga_mids
alamedas1145443alamedas
alexias14249793a_lexias
amias75831473__a_mias
amnesias1047833amnesias
anabas8314083ana__bas
anadems1036143anadem__s
analemma12113893analemma_
analgesias11194063analgesias
analgia898363analgia_
anathemas1444883anathem_as
anatomies11159693anatomies
anemic102713693an_emi_c
anergias947173anergias
angarias9310553angarias
angelicas1244583angelicas
animas84418723an_im_as
animis84615943an_imi_s
annelids946233annelids
anomies93316993an_omies
anopias92412483an_opias
anopsias10337983anopsias
anorexias1644403anorexias
anosmia946643anosmia_
anoxemia1754773anoxemia_
anoxias14259113an_oxias
antennas846403antennas
anthemia1349193anthemia_
antibias10312083antibias
anurias7312253an_urias
aramids102810513ara_mids
asterias8317013asterias
ataxias14189343ata_xias
atresias839473atresias
azotemias2094063azotemias
bohemias1545983bohemias
endemial1146583endemial
endemics1346273endemics
enemas8812003en_em_as
enemies9313693en_emies
haemins122811403_haemins
kalmias1347973_kalmias
lamias85020613_la_mias
nemas75321573_n_em_as
panamas113112763pana_m_as
pandemics1643933pandemics
pyaemia1445733pyaemia_
pyemias1436803_pyemias
santerias9311843santerias
sapraemias1452953sapraemias
sapremias1344953sapremias
taenias7311283_taenias
toxaemias1842813toxaemias
toxemias1744733toxemias
uraemia946503uraemia_
uremias9249503_uremias
viremias1345873viremias
zamias174212923_za_mias

Search took 9 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 Limit146162817.98318309.2
3Display Results81810.0332454.5
 (SQL Overall)178691818.46921099.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.