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

293 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
anemia8261357(None) 
anaemia959801anaemia
anemias92512141anemias
anemic102713691anemic
abelia83114402abelia
acedia9310392acedia
aecia73819282a_ecia
alexia132910462alexia
amia66836902a__mia
amnesia938292amnesia
anaemias1069202anaemias
anaemic1149902anaemic
anergia847362anergia
anima74620072anim_a
animi74016662animi_
animis84615942animis
anomic102516302anomic
anomie83215962anomie
anopia83412392anopia
anosmia946642anosmia
anoxemia1754772anoxemia
anoxia133510022anoxia
anthemia1349192anthemia
anuria6313122anuria
enema7612742enem_a
nema65522522_nem_a
pyemia1337552pyemia
uremia82910892uremia
abasia8712953abasia
abelian92810643abelian
abelias93213563abelias
aboma91114603abom_a
abulia83512503abulia
acacia10311353acacia
academia1345113academia
acedias1039773acedias
acequia1844133acequia
aceta74017353ace_ta
acetic10314503acetic
acetin8314693acetin
acidemia1344783acidemia
acmic11312333a_cmic
acromia1139963acromia
admit8319493a_dmit
admix1557733a_dmix
adnexa1433673adne_xa
adynamia1443123adynamia
aecial84817313a_ecial
aegis6316783a_egis
aerial64625713a_erial
aerie54634603a_erie
agama85815583agam_a
agamic113110563agamic
agamid103710693agamid
agenda837253agenda
agenesia945983agenesia
agma77623263a_gm_a
agnomina1144263agnomina
agnosia837643agnosia
agria65517143a_gria
ahem97225363ahem__
ahimsa1134783ahimsa
akela9311343ake_la
akinesia1284073akinesia
alembic1354773alembic
alevin92511513alevin
alexias14249793alexias
alexin132311483alexin
alma66333023a_lm_a
alodia71112453alodia
alumin8513543alumin
alumina9510053alumina
alumna857343alumna
ama510853303a__m_a
ameba9312383ame_ba
amebic1239113amebic
amentia9310153amentia
ami56646813a__mi_
amias75831473a__mias
amid77036353a__mid
amie66339853a__mie
amiga85514813a__miga
amin66042253a__min
amir65129753a__mir
amis66445323a__mis
amnesiac1265073amnesiac
amnesias1047833amnesias
amnesic1137183amnesic
amnia75918643a_mnia
amusia839173amusia
ana39559833an___a
analemma12113893analemma
analgia898363analgia
ane37866953ane___
anear55420323ane_ar
anears63717183anears
anele55628833ane_le
aneled74719273aneled
aneles64626293aneles
aneling82719503aneling
anemone9119453anemone
anemosis10148073anemosis
anenst63514983anenst
anent54931843ane_nt
anergias947173anergias
anergic1048103anergic
anergy10156863anergy
aneroid8314003aneroid
anes45255933ane__s
aneurin749833aneurin
anew76623133ane__w
anga56831353an__ga
angaria8311583angaria
angelic1039623angelic
angelica1145893angelica
angina7413133angina
angora71111573angora
ani37751183an__i_
anil46437433an__il
anilin6417793anilin
animal85016253animal
animas84418723animas
anime75423203anim_e
animes84719593animes
animism113510213animism
animist93815173animist
animus84211613animus
anis45746463an__is
anisic8313793anisic
anna45529013an__na
annelid838733annelid
annona648873annona
anoa45634473an__oa
anodic92813133anodic
anomies93316993anomies
anomy105113393anom_y
anopias92412483anopias
anopsia9258443anopsia
anorexia1544913anorexia
anosmias1056083anosmias
anosmic1137783anosmic
anoxemias1844543anoxemias
anoxemic1945593anoxemic
anoxias14259113anoxias
anoxic152610673anoxic
ansa45927773an__sa
anta46839583an__ta
antefix1745053antefix
antefixa1843253antefixa
antenna746383antenna
anthelia1149113anthelia
anthemic15410323anthemic
anti45536363an_ti_
antiar6317173an_tiar
antic75728863an_tic
antiman9313883antiman
antis55033313an_tis
antra56521923an_tra
anurias7312253anurias
anuric8812103anuric
anvil82712603an_vil
aphelia1249423aphelia
apnea73413413apne__a
apneic1078623apne_ic
aporia8315863aporia
apteria9312913apteria
aramid93315613aramid
area45843393are__a
areca75618633are_ca
areic73219393are_ic
arena55323813are_na
areola6813673areola
arepa75615563are_pa
aria46245423a__ria
aroma71220143arom_a
asea46327183ase__a
asteria7316183asteria
ataxia13179593ataxia
atelic8313703atelic
atemoya1242933atemoya
atma68121773a_tm_a
atomic104115603atomic
atonia63816513atonia
atresia7310223atresia
atria56022343a_tria
axeman1538103axeman
axemen1547493axemen
axenic154210003axenic
azotemia19104173azotemia
babesia1146623babesia
banksia1335943banksia
bema85825253_bem_a
bemix165011453_bemix
bohemia1446363bohemia
camelia11510433camelia
canella9310793canella
ceria75125353_ceria
chemic153012093chemic
cinema1047653cinem_a
coremia11310363coremia
demic105119193_demic
demit84832303_demit
edema8610553edem_a
elemi7312503elemi_
elemis8312383elemis
emic86422753__emic
emir65918703__emir
emit65438423__emit
encomia1147983encomia
endemial1146583endemial
endemic1237893endemic
enemas8812003enemas
enemata948013enemata
enemies9313693enemies
enemy1059993enem_y
entia5318203en_tia
fanega1055783fane_ga
feria85922713_feria
ganglia946613ganglia
gemma106311773_gemma
gnomic11248593gnomic
gremial1039153gremial
gynecia1384233gynecia
haemic133210083haemic
haemin113412663haemin
hemic125718623_hemic
hemin103620933_hemin
inedita846793inedita
inertia7410203inertia
inia45024703in__ia
intima81910033intima
kalmia1238893kalmia
kinema1236023kinem_a
lamia75324323_lamia
lemma94811033_lemma
magnesia1145723magnesia
mania75634153man__ia
manumit1149573manumit
maremma1044463maremma
media84721713_media
naevi867873naevi_
neif75429493_ne_if
nemas75321573_nemas
neumic1036853_neumic
nevi75116423_nevi_
newie81813483_newie
noma67529463_nom_a
nomina83113683_nomina
noria55722183_noria
nubia7311233_nubia
numina83510843_numina
obelia8329453obelia
panama104213353panam_a
pandemic1545543pandemic
pennia84412973pennia
pneuma1035263pneuma
premie103617993premie
premix173710333premix
pyaemia1445733pyaemia
pyemias1436803pyemias
pyemic1537893pyemic
racemic1336983racemic
redia65524483_redia
reemit8717223reemit
remit75737223_remit
remix145916553_remix
retia55326113_retia
sangria838113sangria
santeria8311653santeria
sapremia1245203sapremia
semi65127223_semi_
semina8915563_semina
semis74623533_semis
sepia75318673_sepia
stemma10328133stemma
taenia6313193taenia
taxemic1835243taxemic
telia55821143_telia
tenia55324483_tenia
tonemic11310173tonemic
toxemia1644873toxemia
ulema7109713ulem_a
uncia75015163un_cia
unmix14388973un_mix
uraemia946503uraemia
uredia73610063uredia
uremias9249503uremias
uremic103410513uremic
urinemia1043953urinemia
viremia1246083viremia
xenia124814773_xenia
zamia165115213_zamia
zoecia1735553zoecia

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162935.51620434.4
3Display Results2932930.0933150.5
 (SQL Overall)1786912935.74931082.1
 
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.