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) 
asteria7316171asteria
aphelia1249422aphelia
aporia8315862ap_oria
apter76120202apter__
apteral9311522apteral
apterium1249132apterium
apteryx1942382apteryx
arterial8313622arterial
asterias8317002asterias
atria56022332a_t_ria
bacteria1248982bacteria
hatteria1137862hatteria
pterin81014152_pterin
santeria8311642santeria
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
amberina1247383amberina
amnesia938293amnesia
anaemia959803anaemia
anemia82613573a_nemia
anergia847363a_nergia
angaria8311553angaria
antefix1745053antefix
antefixa1843253antefixa
antenna746383antenna
anterior8611053anterior
anthelia1149113anthelia
anthemia1349193anthemia
antherid12611093antherid
antra56521923ant_r_a
anuria6313103a_nuria
apatetic1258573apatetic
aper66336233ap_er__
apercu1057383ap_ercu
aperies9423203ap_eries
apers76629133ap_er_s
apery106517903ap_er_y
aphagia13247663aphagia
aphasia122510873aphasia
aphelian1376963aphelian
aphesis12610513aphesis
aphetic142912853aphetic
aphonia122711883aphonia
apiarian1048313apiarian
aplasia92510803aplasia
apnea73413413apne__a
apneic1078623apne_ic
aporias9315133ap_orias
apothecia1644003apothecia
apraxia1646893apraxia
apterous10410463apterous
aptest82917513apte_st
aquaria1638033aquaria
aria46245423a___ria
arterials949683arterials
arteries8321463arteries
artery9911453arter_y
aspheric1547983aspheric
astasia7310933astasia
aster55434893aster__
asterisk1248673asterisk
asterism10413253asterism
astern64815813aster_n
asternal858313asternal
asteroid9511173asteroid
asters65631603aster_s
asthenia1167713asthenia
ataxia13179593a_taxia
atelic8313703a_telic
atonia63816513a_tonia
atresia7310223atresia
atrial65418943a_t_rial
atrip75315743a_t_rip
attrit6315743a_ttrit
azotemia19104173azotemia
azoturia1742793azoturia
bacterial1348353bacterial
bacterias1349273bacterias
bacterin12410273bacterin
baptisia1245013baptisia
batterie10711533batterie
bothria1246443bothria
cafeteria1453793cafeteria
capoeira1243353capoeira
ceria75125353__ceria
coterie9417393coterie
criteria1047993criteria
diptera1037203dipter_a
entera64216833enter_a
enteric9314213enteric
feria85922713__feria
feterita1166463feterita
galleria946473galleria
haptenic1545763haptenic
hatterias1258733hatterias
hysteria1447383hysteria
icteric1138023icteric
imperia1148423imperia
interim9912873interim
latria62313583lat_ria
listeria839423listeria
material10314093material
niterie7313743niterie
nutria639903nut_ria
opera7313573op_er_a
papeterie1345193papeterie
pareira937533pareira
parerga1035173parerga
patagia1068783patagia
patella938953patella
pater74740723pater__
paternal1038333paternal
paters84935823pater_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
santerias9311833santerias
sapremia1245203sapremia
septaria1047413septaria
spheric14510073spheric
splenia948313splenia
steric8317063_steric
sterna63712763_sterna
stria55723203_st_ria
taqueria1743393taqueria
telia55821143__telia
tenia55324483__tenia
terai53525483__terai
terbia8311153__terbia
terga63315643__terga
terra54419653__terra
uteri51012983_uteri_
wasterie111211583wasterie
wisteria1147743wisteria
ytterbia1342183ytterbia
yttria954803_yttria

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.1701051123.5
2DLD Change Limit1340271647.97016816.4
3Display Results1641640.1261301.6
 (SQL Overall)1786911648.26621617.6
 
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.