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

497 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
altered8321573(None) 
alterer72713991alterer
faltered122810981faltered
haltered123112551haltered
paltered113012481paltered
adhered1239232adhered
alerted82512222al_erted
aliened81011742aliened
alleged9389312alleged
allured8299172allured
alter54828502alter__
alterers82512492alterers
alters64924222alter_s
angered93013472angered
anteed75616112ante_ed
antired82316192antired
antlered938252antlered
attired8238912attired
bantered113313632bantered
bartered113113012bartered
battered113315052battered
cantered113415982cantered
catered103117762catered
entered82718882entered
falterer11239852falterer
filtered12259042filtered
fleered11309502fleered
gartered10319582gartered
haltere103614702haltere_
halteres113414592halteres
lagered92311152lagered
latened8711922latened
laterad8310832laterad
lathered121512322lathered
layered11259412layered
leered73816222_leered
mastered112614002mastered
mattered112412902mattered
metered103514012metered
mitered103213232mitered
nattered92011622nattered
palterer102411272palterer
pattered112714202pattered
peltered112510442peltered
petered103314962petered
raftered1237662raftered
realtered1037892realtered
tattered92011442tattered
ulcered1037972ulcered
unaltered1037722unaltered
uttered82712432uttered
waitered1238752waitered
watered113014952watered
weltered12238432weltered
yattered12239532yattered
abetted1058323abetted
abjured1735073abjured
absterged1353353absterged
acceded1336093acceded
acred87126353a__cred
acted88521733act__ed
adeemed1145393adeemed
adhere10310333adhere_
adherend1343863adherend
adherer1137563adherer
adheres11310163adheres
adjured1634873adjured
admired1135703admired
adored84714233a_dored
adulterer1043553adulterer
adverted1336103adverted
aeried74221863a__eried
afeared1176833afeared
after85719793after__
afters94717073after_s
agreed84712503agre_ed
aired66032923a__ired
alarmed1037733alarmed
alated75625143al_ated
alcoved1375613alcoved
alder65421913alder__
aldermen1145043aldermen
alders74218423alder_s
alee46652323al_e_e_
alert54740653al_er_t
alerter72111513al_erter
alerts64418223al_erts
alfredo1142483al_fredo
alibied1038143alibied
alienee71013153alienee
aliener71011193aliener
aligned9128553aligned
alined75221403al_ined
aliped95414283al_iped
alkene104114003alkene_
alkenes114212753alkenes
allayed11138063allayed
allee54932123alle_e_
allees64521483alle_es
allege74314643allege_
alleger8319623alleger
alleges84212563alleges
allele64514563allele_
alleles73812033alleles
allergen9135883allergen
allergy1144503allergy
allied74217153al_lied
allowed111610073allowed
alloyed11158033alloyed
allseed835953allseed
alluded9327093alluded
allure63012943allure_
allurer7348433allurer
allures72913113allures
altar55520643altar__
altars64518153altar_s
alterant8614963alterant
altercated1345453altercated
altering91917113altering
alterity1149843alterity
alternated1145723alternated
althaea1044353althaea
althea938193alt_hea
amerced1256523a_merced
ampere10514413ampere_
amperes11313983amperes
aneared8512743aneared
aneled74719273a_neled
angeled93211493angeled
annexed1535753annexed
answered1235483answered
antecede1145023antecede
anted66328243ant__ed
anthemed1446953anthemed
antherid12611093antherid
antre55224523ant_re_
antres65021003ant_res
appeared1336143appeared
apter76120203apter__
apteral9311523apteral
apteria9312913apteria
apteryx1942383apteryx
arbored103811603arbored
armored102610473armored
arteries8321463arteries
artery9911453arter_y
ascared10399523ascared
ashlered1244623ashlered
aspersed11428293aspersed
aspired1068173aspired
asserted957903asserted
assured858373assured
aster55434893aster__
asteria7316173asteria
astern64815813aster_n
asteroid9511173asteroid
asters65631603aster_s
atoned75417543a_toned
attend7258973atte_nd
attended1035763attended
attested936293attested
attire62412383attire_
attires72312953attires
attorned955353attorned
attuned835173attuned
augured987193augured
austere7312993austere_
austerer838383austerer
authored1238263authored
autoed7712823aut_oed
averred11237593averred
averted112211613a_verted
axletree1543973axletree
axseed1456993axse_ed
badgered1336213badgered
bannered11299323bannered
banterer102811773banterer
barbered13259543barbered
barterer102711633barterer
battened11259573battened
batterer102713213batterer
bettered113011833bettered
bistered112913323bistered
bittered112711833bittered
blared95018243bl_ared
blathered15168353blathered
blattered12198563blattered
blazered2035063blazered
bleared104211253bleared
bleed85019803bl_e_ed
bleeped12287273bleeped
blethered15165433blethered
blistered12167683blistered
blithered15156123blithered
blurred10427803blurred
blustered12157263blustered
bolstered1246083bolstered
bothered142110393bothered
bowered133113043bowered
buttered112712623buttered
calibred1335053calibred
calipered1454873calipered
cambered15128993cambered
cancered132411553cancered
cankered153010223cankered
capered123014043capered
captured1336563captured
careered1139493careered
caterer92815933caterer
centered112513523centered
cered85227443__cered
chaptered17176783chaptered
chartered15158383chartered
chattered15197983chattered
cheered133713293cheered
clattered12178403clattered
clavered14187633clavered
cleared103612463cleared
cleeked14357733cleeked
cleped115114113cl_eped
clerid9312413cl_erid
clerked14326653cl_erked
clewed1225113203cl_ewed
clotured11246163clotured
cloured103111543cloured
clovered14187363clovered
clustered12186603clustered
cluttered12185933cluttered
cohered133514693cohered
cottered112511733cottered
covered133315293covered
cowered133214643cowered
cratered1149673cratered
cultured1137233cultured
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
deterged11127923deterged
deterred10137803deterred
dithered13189293dithered
dowered122811553dowered
elaterid948613elaterid
enterer72015633enterer
factored1436213factored
falter94519053falter__
falterers12238033falterers
falters103916473falter_s
fastened12257853fastened
fathered151510433fathered
fattened12268283fattened
festered122512103festered
fettered12259493fettered
fevered14339723fevered
fibered1337643fibered
filterer11258143filterer
flared105317603fl_ared
flattered13188623flattered
fleeced13358153fleeced
fleeted113310233fleeted
flexed17419083fl_exed
fleyed13408813fl_eyed
flittered13196253flittered
floored11268683floored
floured11289873floured
flowered1546013flowered
flustered13185883flustered
fluttered13185943fluttered
fostered122210443fostered
fullered1236383fullered
galere73716673gal_ere_
galeres83514323gal_eres
galleried1146923galleried
galleted1038213galleted
gandered112211173gandered
garnered10247113garnered
gathered13149373gathered
gettered10258613gettered
glaired9387743glaired
glared84715193gl_ared
gleed75320573gl_e_ed
gleeked13346333gleeked
gleeted9379323gleeted
gleyed11478153gl_eyed
glistered11176293glistered
glittered11195403glittered
glowered1345753glowered
guttered10259153guttered
halberd1336043halber_d
halted105019603halt__ed
halter94420883halter__
halters104619803halter_s
hammered16218843hammered
hampered16239923hampered
hankered16289443hankered
hastened12239103hastened
hatred104814333hat_red
havered144011453havered
hollered1237603hollered
holstered1345873holstered
homered133212713homered
hovered143411573hovered
inhered11313163inhered
interbed112413103interbed
interned93016653interned
interred92615263interred
itemed936603_itemed
jabbered2034433jabbered
jeered143912793_jeered
jittered16267223jittered
kashered1636403kashered
laagered1055853laagered
labeled102510563labeled
labored102810243labored
lackered15108673lackered
laddered1136743laddered
ladened979053ladened
laired75216813_laired
lakebed1434783lakebed
lapeled10258893lapeled
lappered13288213lappered
latched133914063latched
lated65240673lat__ed
lateen64014863late_en
later54843923later__
lateral7313563lateral
lateraled1047453lateraled
laterized1979903laterized
latexes1438313latexes
lathed104718453lat_hed
latherer111310443latherer
laveered1235253laveered
lawyered1534033lawyered
letted74118543_letted
lettered92910783lettered
levered114212303levered
littered92511383littered
livered113111633livered
loitered938183loitered
loured74617403_loured
lowered112711913lowered
lured65427493_l_ured
lustered92510603lustered
malted94819853malt__ed
mammered12237653mammered
mannered11249653mannered
martyred1434283martyred
matured10310033matured
metred95315143met_red
misaltered1344563misaltered
miterer92511333miterer
mitred94414343mit_red
moldered1237173moldered
mothered142310103mothered
motored1039933motored
mustered112511503mustered
muttered112610793muttered
natured838963natured
neutered937423neutered
ochered132610283ochered
offered1436143offered
ordered9108533ordered
osiered837123osiered
outbred10311263outbred
overed102216623_overed
oystered1236913oystered
palavered1543923palavered
palleted1139863palleted
palter84423263palter__
palterers11249533palterers
palters94021683palter_s
pampered15229223pampered
pandered121812573pandered
papered122513163papered
partnered1244473partnered
pastored1139963pastored
pastured1138233pastured
pattened11299393pattened
patterer103112173patterer
patterned1265743patterned
paupered13216933paupered
peered93819483_peered
pestered112814953pestered
philtered1545493philtered
pilfered1435853pilfered
plastered1288893plastered
portered112311533portered
pothered142311043pothered
pottered112311663pottered
powered132911643powered
prealtered1344923prealtered
puttered112611143puttered
quartered19155963quartered
queered17117213queered
rapiered1136053rapiered
raptured1155463raptured
rattened9218623rattened
retired84620143retired
revered112819333revered
rogered939553rogered
sabered103213023sabered
saggered11237553saggered
salted74121203salt__ed
salter64325083salter__
saltern74010653salter_n
salterns8388893salterns
salters73622253salter_s
saltire73113033saltire_
saltires83112423saltires
sauntered1036283sauntered
sauteed8349613saute_ed
scattered12197353scattered
sered65737293__sered
severed113513863severed
sewered112911243sewered
shattered13178203shattered
sheered113515453sheered
sheltered1335573sheltered
silvered12237563silvered
sintered92213903sintered
sistered92612803sistered
skeltered1443873skeltered
slathered13148533slathered
slavered12188033slavered
sleeked123510883sleeked
sleeted83113223sleeted
sleeved11419913sleeved
slewed104815523sl_ewed
slithered13136623slithered
slivered12218103slivered
slurred8359183slurred
smattered12186783smattered
sneered83113973sneered
sobered102912433sobered
soldered1038153soldered
spattered12187643spattered
speered103614813speered
sphered133512313sphered
spiered104412463spiered
stared75429873_stared
steed66024943_ste_ed
steered83615253steered
stere55328543_stere_
stereo65317913_stereo
steres63929533_steres
stewed104814243_stewed
stored75524213_stored
supered10316123supered
sutured8310373sutured
sweltered1344453sweltered
tabered103311593tabered
tampered13279463tampered
tapered102612933tapered
tared69340053__tared
tautened935423tautened
teared75722153__teared
teed55439263__te_ed
teetered9258303teetered
telfered1234883telfered
tentered96412103tentered
teredo7310783__teredo
termed94816703__termed
tethered1238493tethered
tewed94718533__tewed
tiered73613973_tiered
tillered937433tillered
tired65228903__tired
tittered9239493tittered
tottered9208703tottered
towered112911403towered
treed65626733__treed
tutored837553tutored
tyred95816433__tyred
ultrared936663ultrared
umbered121510113umbered
untired82316383untired
ushered1139153ushered
utterer71910463utterer
valeted1139013val_eted
valleyed1534013valleyed
veered103612743_veered
wafered14288433wafered
wagered12299333wagered
walleyed1534153walleyed
waltzed2033493walt_zed
wandered132110793wandered
waterbed1436443waterbed
waterer103314073waterer
wavered142910433wavered
westered122511863westered
wildered1336633wildered
wintered122111573wintered
withered15169433withered
wuthered15157433wuthered
yabbered1633963yabbered
yammered16225763yammered

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.1401276364.3
2DLD Change Limit1340274977.87317023.6
3Display Results4974970.1902615.8
 (SQL Overall)1786914978.20321783.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.