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
apteria931292(None) 
asteria7316201asteria
aphelia1249422aphelia
aporia8315862ap_oria
apter76120202apter__
apteral9311522apteral
apterium1249152apterium
apteryx1942382apteryx
arterial8313652arterial
asterias8317042asterias
atria56022352a_t_ria
bacteria1249002bacteria
hatteria1137882hatteria
pterin81014152_pterin
santeria8311672santeria
abelia83114413a_belia
acedia9310403a_cedia
actinia91710863actinia
aecia73819283a__ecia
aerial64625713a__erial
aerie54634603a__erie
aetheric13410163aetheric
after85719793after__
afters94717073after_s
aftertax1843233aftertax
agria65517143a__gria
alexia132910463a_lexia
alter54828503alter__
altered83215753altered
alterer72714013alterer
altering91917123altering
alterity1149853alterity
alters64924223alter_s
amberina1247403amberina
amnesia938293amnesia
anaemia959803anaemia
anemia82613573a_nemia
anergia847373a_nergia
angaria8311583angaria
antefix1745053antefix
antefixa1843263antefixa
antenna746383antenna
anterior8611073anterior
anthelia1149113anthelia
anthemia1349203anthemia
antherid12611093antherid
antra56521923ant_r_a
anuria6313133a_nuria
apatetic1258593apatetic
aper66336233ap_er__
apercu1057383ap_ercu
aperies9423203ap_eries
apers76629133ap_er_s
apery106517903ap_er_y
aphagia13247663aphagia
aphasia122510873aphasia
aphelian1376963aphelian
aphesis12610513aphesis
aphetic142912853aphetic
aphonia122711883aphonia
apiarian1048333apiarian
aplasia92510803aplasia
apnea73413413apne__a
apneic1078623apne_ic
aporias9315163ap_orias
apothecia1644013apothecia
apraxia1646893apraxia
apterous10410483apterous
aptest82917513apte_st
aquaria1638043aquaria
aria46245433a___ria
arterials949733arterials
arteries8321513arteries
artery9911453arter_y
aspheric1547983aspheric
astasia7310933astasia
aster55434893aster__
asterisk1248693asterisk
asterism10413273asterism
astern64815813aster_n
asternal858323asternal
asteroid9511213asteroid
asters65631603aster_s
asthenia1167723asthenia
ataxia13179593a_taxia
atelic8313713a_telic
atonia63816513a_tonia
atresia7310243atresia
atrial65418943a_t_rial
atrip75315753a_t_rip
attrit6315753a_ttrit
azotemia19104173azotemia
azoturia1742833azoturia
bacterial1348373bacterial
bacterias1349303bacterias
bacterin12410283bacterin
baptisia1245023baptisia
batterie10711543batterie
bothria1246453bothria
cafeteria1453823cafeteria
capoeira1243363capoeira
ceria75125363__ceria
coterie9417403coterie
criteria1048013criteria
diptera1037213dipter_a
entera64216833enter_a
enteric9314213enteric
feria85922713__feria
feterita1166483feterita
galleria946493galleria
haptenic1545763haptenic
hatterias1258763hatterias
hysteria1447403hysteria
icteric1138033icteric
imperia1148423imperia
interim9912873interim
latria62313613lat_ria
listeria839453listeria
material10314113material
niterie7313743niterie
nutria639913nut_ria
opera7313573op_er_a
papeterie1345193papeterie
pareira937553pareira
parerga1035173parerga
patagia1068783patagia
patella938963patella
pater74740733pater__
paternal1038333paternal
paters84935843pater_s
peerie83617893_peerie
perea75026443_p_erea
pereia85217983_p_ereia
peri65636973_p_eri_
peril75425953_p_eril
peris75537073_p_eris
psalteria1144013psalteria
pterins9812993_pterins
pterygia1442413_pterygia
pteryla1243303_pteryla
pyemia1337553_pyemia
pyuria1136953_pyuria
raptorial1147433raptorial
santera7311313santer_a
santerias9311863santerias
sapremia1245203sapremia
septaria1047413septaria
spheric14510073spheric
splenia948313splenia
steric8317063_steric
sterna63712763_sterna
stria55723213_st_ria
taqueria1743413taqueria
telia55821143__telia
tenia55324483__tenia
terai53525483__terai
terbia8311163__terbia
terga63315643__terga
terra54419673__terra
uteri51012983_uteri_
wasterie111211593wasterie
wisteria1147773wisteria
ytterbia1342193ytterbia
yttria954803_yttria

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 Limit1340271647.29618369.9
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.78222962.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.