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

150 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
atresic931000(None) 
atresia7310221atresia
atretic9313921atretic
agrestic1147922agrestic
amnesic1137182amnesic
areic73219392a_re_ic
atelic8313702at_elic
atresias839472atresias
abrosia939273abrosia
acerbic1335643acerbic
acetic10314503a_cetic
acrasia9310033acrasia
acrasin9311223acrasin
acres76327763acres__
acronic112814693acronic
acrostic1239943acrostic
acrotic112515533acrotic
acrylic1496283acrylic
actress948533actres_s
actressy1342603actressy
aerobic11310213aerobic
aetheric13410163aetheric
afresh1255503afres_h
agravic1345883agravic
airest63825263aires_t
airsick1395333air_sick
allelic9118173allelic
aloetic9313183aloetic
amebic1239103a_mebic
amnesia938293amnesia
amnesiac1265073amnesiac
amnesics1255283amnesics
amnestic1247053amnestic
amoebic1346153amoebic
anaemic1149903anaemic
anemic102713693a_nemic
anergic1048103anergic
angelic1039613angelic
anisic8313793a_nisic
anoretic10312933anoretic
anorexic1745733anorexic
anthemic15410323anthemic
anthesis11312493anthesis
antres65021003antres__
anuresis846963anuresis
anuretic1048563anuretic
aoristic10311163aoristic
aortic8316613aor_tic
aphasic142810063aphasic
aphesis12610513aphesis
aphetic142912853aphetic
apneic1078623apne_ic
apraxic1846293apraxic
apres75426403apres__
aprotic112715233aprotic
apyretic1546843apyretic
arabic10312733a_rabic
arctic10313513a_rctic
ares45871023a_res__
arkosic1346053arkosic
arrest63722633arres_t
arrests73312683arrests
arsenic939323arsenic
arsis55722423a_r_sis
artistic10310893artistic
asbestic1245383asbestic
ascesis938373ascesis
ascetic11310063ascetic
askesis1136123askesis
asthenic1378633asthenic
atactic11410083atactic
ataraxic1743923ataraxic
atavic11189293at_avic
ataxic15169203at_axic
ates45047923at_es__
atheism1248523atheism
atheist10314053atheist
atheistic1447333atheistic
athletic13118643athletic
atomic104115603at_omic
atonic83420473at_onic
atopic103514143at_opic
atria56022333atr__ia
atrip75315743atr__ip
atrophic1549373atrophic
atropin9311583atropin
attest62618613attes_t
attests7278813attests
attic75618353at__tic
atypic13337653at_ypic
aurei54821863aure_i_
aures55137093aures__
auric74521723aur__ic
autopsic1246063autopsic
auxesis1445443auxesis
auxetic1637143auxetic
axenic154210003a_xenic
bathetic1548573bathetic
cretic102816283_cretic
crisic103611843_crisic
ecesic10369223_ecesic
eirenic939003eirenic
etheric12311783etheric
forensic1344943forensic
heretic12314833heretic
iatric8312153iatr__ic
irenic8311103_irenic
kinesic13257023kinesic
magnesic1345753magnesic
matres84522233matres__
mesic93617863__mesic
paresis93315093paresis
paretic113016673paretic
pathetic15410943pathetic
patristic1389273patristic
phrenic1438773phrenic
pyretic143210783pyretic
pyrexic21235353pyrexic
relic74623363__relic
resid64124093__resid
resin54131053__resin
resit54241043__resit
sapremic1445333sapremic
stelic8313083st_elic
steric8317063st_eric
sthenic1268903sthenic
stress66616673stres_s
strobic1138243strobic
tabetic1138463tabetic
tares57456563tares__
tarsi55222173tar_si_
tarsia65514273tar_sia
taxemic1835243taxemic
telic76019823_t_elic
terbic10410963_terbic
terebic1137983terebic
thesis94913733_thesis
thetic11412883_thetic
tmesis8529793_tmesis
tragic93811543_tragic
trepid9310083_trepid
tres46542903_tres__
tress55423163_tres_s
tressy9448553_tressy
trismic1137473_trismic
tropic103014193_tropic
ureic74514463_ure_ic
uremic103410513_uremic
uretic82914353_uretic
viremic1436153viremic

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271507.92316916.2
3Display Results1501500.0602500.0
 (SQL Overall)1786911508.13921954.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.