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

136 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
atresia731022(None) 
atresias839471atresias
atresic9310001atresic
abrosia939272abrosia
acrasia9310032acrasia
amnesia938292amnesia
atretic9313922atretic
atria56022342atr__ia
tarsia65514272tar_sia
abasia8712953a_basia
abelia83114403a_belia
abrosias1049033abrosias
acedia9310393a_cedia
acrasias1048893acrasias
acrasin9311223acrasin
acres76327763acres__
acromia1139963acromia
actress948533actres_s
actressy1342603actressy
aecia73819283a__ecia
aerobia939463aerobia
aesthesia1245943aesthesia
afresh1255503afres_h
agenesia945983agenesia
agnosia837643agnosia
agrestal945653agrestal
agrestic1147923agrestic
agria65517143agr__ia
airest63825263aires_t
akinesia1284073akinesia
alexia132910463a_lexia
ambrosia1245543ambrosia
amnesiac1265073amnesiac
amnesias1047833amnesias
amnesic1137183amnesic
amreeta945163amreeta
amusia839173a_musia
anaemia959803anaemia
anemia82613573a_nemia
anergia847363anergia
anopsia9258443anopsia
anorexia1544913anorexia
anthelia1149113anthelia
anthemia1349193anthemia
anthesis11312503anthesis
antres65021003antres__
anuresis846963anuresis
aphasia122510873aphasia
aphelia1249423aphelia
aphesis12610513aphesis
aplasia92510803aplasia
apraxia1646893apraxia
apres75426403apres__
apteria9312913apteria
area45843393a_re__a
areca75618633a_re_ca
areic73219393a_re_ic
arena55323813a_re_na
areola6813673a_reola
arepa75615563a_re_pa
ares45871023a_res__
aria46245423a_r__ia
arista6415293a_rista
arrest63722633arres_t
arrests73312683arrests
arsis55722423a_r_sis
artemisia1153053artemisia
arterial8313633arterial
ascesis938373ascesis
askesis1136123askesis
astasia7310933astasia
asteria7316183asteria
asthenia1167713asthenia
ataraxia1544173ataraxia
ataxia13179593at_axia
atelic8313703at_elic
ates45047923at_es__
atheism1248523atheism
atheist10314063atheist
atonia63816513at_onia
atrial65418943atr__ial
atrip75315753atr__ip
atrophia1348103atrophia
atropin9311583atropin
attest62618613attes_t
attests7278813attests
aubretia1045263aubretia
aurei54821863aure_i_
aureola747033aureola
aures55137093aures__
auxesis1445443auxesis
babesia1146623babesia
cabresta1243993cabresta
coremia11310363coremia
esthesia1147503esthesia
etesian757853et_esian
freesia1046323freesia
hatteria1137863hatteria
latria62313593latr__ia
magnesia1145723magnesia
matres84522233matres__
paresis93315093paresis
pereia85217983pere_ia
presa74319043_pres_a
pyrexia19225463pyrexia
redia65524483__redia
resid64124093__resid
resin54131053__resin
resit54241043__resit
retia55326113__retia
sapremia1245203sapremia
silesia739083silesia
sthenia1058503sthenia
stokesia1243963stokesia
stress66616673stres_s
stretta737293stretta
stria55723213str__ia
taenia6313193_taenia
tares57456563tares__
tarsi55222173tar_si_
tarsias74013373tar_sias
telia55821143_t_elia
tenia55324483_t_enia
terbia8311153_terbia
tesla55612603_t_esla
testa54822043_t_esta
thesis94913733_thesis
tmesis8529793_tmesis
trepid9310083_trepid
tres46542903_tres__
tress55423163_tres_s
tressy9448553_tressy
trivia938503_trivia
uredia73610063_uredia
uremia82910893_uremia
viremia1246083viremia

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.423422437.4
2DLD Change Limit1340271366.78019768.0
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.24924650.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.