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

164 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
apteria931291(None) 
asteria7316181asteria
aphelia1249422aphelia
aporia8315862ap_oria
apter76120202apter__
apteral9311522apteral
apterium1249132apterium
apteryx1942382apteryx
arterial8313632arterial
asterias8317012asterias
atria56022342a_t_ria
bacteria1248982bacteria
hatteria1137862hatteria
pterin81014152_pterin
santeria8311652santeria
abelia83114403a_belia
acedia9310393a_cedia
actinia91710853actinia
aecia73819283a__ecia
aerial64625713a__erial
aerie54634603a__erie
aetheric13410163aetheric
after85719793after__
afters94717073after_s
aftertax1843233aftertax
agria65517143a__gria
alexia132910463a_lexia
alter54828503alter__
altered83215733altered
alterer72713993alterer
altering91917113altering
alterity1149843alterity
alters64924223alter_s
amberina1247393amberina
amnesia938293amnesia
anaemia959803anaemia
anemia82613573a_nemia
anergia847363a_nergia
angaria8311583angaria
antefix1745053antefix
antefixa1843253antefixa
antenna746383antenna
anterior8611053anterior
anthelia1149113anthelia
anthemia1349193anthemia
antherid12611093antherid
antra56521923ant_r_a
anuria6313123a_nuria
apatetic1258583apatetic
aper66336233ap_er__
apercu1057383ap_ercu
aperies9423203ap_eries
apers76629133ap_er_s
apery106517903ap_er_y
aphagia13247663aphagia
aphasia122510873aphasia
aphelian1376963aphelian
aphesis12610513aphesis
aphetic142912853aphetic
aphonia122711883aphonia
apiarian1048323apiarian
aplasia92510803aplasia
apnea73413413apne__a
apneic1078623apne_ic
aporias9315153ap_orias
apothecia1644013apothecia
apraxia1646893apraxia
apterous10410463apterous
aptest82917513apte_st
aquaria1638043aquaria
aria46245423a___ria
arterials949693arterials
arteries8321483arteries
artery9911453arter_y
aspheric1547983aspheric
astasia7310933astasia
aster55434893aster__
asterisk1248673asterisk
asterism10413253asterism
astern64815813aster_n
asternal858323asternal
asteroid9511193asteroid
asters65631603aster_s
asthenia1167713asthenia
ataxia13179593a_taxia
atelic8313703a_telic
atonia63816513a_tonia
atresia7310223atresia
atrial65418943a_t_rial
atrip75315753a_t_rip
attrit6315753a_ttrit
azotemia19104173azotemia
azoturia1742813azoturia
bacterial1348363bacterial
bacterias1349283bacterias
bacterin12410273bacterin
baptisia1245013baptisia
batterie10711533batterie
bothria1246443bothria
cafeteria1453803cafeteria
capoeira1243353capoeira
ceria75125353__ceria
coterie9417403coterie
criteria1047993criteria
diptera1037213dipter_a
entera64216833enter_a
enteric9314213enteric
feria85922713__feria
feterita1166463feterita
galleria946473galleria
haptenic1545763haptenic
hatterias1258743hatterias
hysteria1447393hysteria
icteric1138023icteric
imperia1148423imperia
interim9912873interim
latria62313593lat_ria
listeria839433listeria
material10314103material
niterie7313743niterie
nutria639913nut_ria
opera7313573op_er_a
papeterie1345193papeterie
pareira937533pareira
parerga1035173parerga
patagia1068783patagia
patella938953patella
pater74740723pater__
paternal1038333paternal
paters84935833pater_s
peerie83617893_peerie
perea75026443_p_erea
pereia85217983_p_ereia
peri65636973_p_eri_
peril75425953_p_eril
peris75537073_p_eris
psalteria1144003psalteria
pterins9812993_pterins
pterygia1442403_pterygia
pteryla1243303_pteryla
pyemia1337553_pyemia
pyuria1136953_pyuria
raptorial1147433raptorial
santera7311303santer_a
santerias9311843santerias
sapremia1245203sapremia
septaria1047413septaria
spheric14510073spheric
splenia948313splenia
steric8317063_steric
sterna63712763_sterna
stria55723213_st_ria
taqueria1743403taqueria
telia55821143__telia
tenia55324483__tenia
terai53525483__terai
terbia8311153__terbia
terga63315643__terga
terra54419663__terra
uteri51012983_uteri_
wasterie111211583wasterie
wisteria1147753wisteria
ytterbia1342183ytterbia
yttria954803_yttria

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.1531167915.0
2DLD Change Limit1340271646.42320866.7
3Display Results1641640.0632603.2
 (SQL Overall)1786911646.63926915.3
 
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.