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

219 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
appends123639(None) 
append1138271append_
addends10356052addends
amends94713282a_mends
appeals11378672appeals
appears11308952appears
appels104312792appe_ls
appended1435482appended
appendix2042272appendix
arpens84814822arpen_s
arpents93613082arpents
ascends10388202ascends
aspens85013352aspen_s
attends8257592attends
augends935882augends
depends11348992depends
expends17217082expends
happens14359172happen_s
impends12376802impends
pends85527192__pends
spends94714472_spends
upends9438762_upends
upsends10265292upsends
abounds10217083abounds
absents93510723absents
accents113511233accents
achenes12313493achenes
addend9458453addend_
addenda10364463addenda
advents11309473advents
agenda837253a_genda
agendas936933a_gendas
agenes74720253a_genes
agents74816293a_gents
akenes104817343a_kenes
alands75418373a_lands
aliens65619213alien_s
alipeds10386793alipe_ds
alkenes114212753alkenes
almonds10127953almonds
alpines94016193alpines
amend85717753a_mend_
amens75624843a_men_s
aments85219803a_ments
amped104820513ampe_d_
amperes11313983amperes
ands57833613a___nds
aped78538153a_pe_d_
apers76629133a_pe_rs
apes66047433a_pe__s
apexes1539133a_pexes
apheses12610703apheses
aphesis12610513aphesis
aphids125110843a_phids
aplenty1237173aplenty
apneas83211383apne_as
apods86316343a_p_ods
appalls11337743appalls
appals104812943app_als
appeal103911613appe_al
appear10379343appe_ar
appease1137913appease
appeases1238663appeases
appel94615893appe__l
appendage1553343appendage
appendages1653243appendages
appendant1455733appendant
appendants1544063appendants
appendent1446273appendent
appendents1544403appendents
appendices1743463appendices
appending1536283appending
appendixes2252443appendixes
applauds13103283applauds
apples104315763app_les
applets115710063applets
applies11311213applies
appoints1286403appoints
apposes11511473apposes
apprehends1852503apprehends
apps86319693app___s
apres75426403apre__s
aprons8316993apron_s
apses76823913apse__s
aptness9268573aptness
arenas65021993a_renas
arenes64928393a_renes
argents84014853argents
arpen74418043arpen__
arpent84822093arpen_t
ascend9429733ascend_
ascents93812553ascents
aspects1146743aspects
aspen75216093aspen__
aspers86220313aspe_rs
assents74512223assents
attend7258973attend_
augend837633augend_
avens86419333a_ven_s
axseeds1533393axseeds
bartends1136793bartends
bends85628973__bends
bipeds11458053bipe_ds
blends96012883_blends
calends1039523calends
capped134721853cappe_d_
cappers134419403cappe_rs
cappings15369493cappings
compends15378253compends
copens106119963copen_s
dampens12348563dampen_s
dapped124516763dappe_d_
defends12358773defends
depend103510923depend_
dispends12308533dispends
emends95711433_emends
ends56528523___ends
expands17195733expands
expend16247503expend_
extends15227113extends
faciends1443573faciends
fends96324973__fends
fiends104110293_fiends
friends11396743friends
gapped124217123gappe_d_
happed144820103happe_d_
happen134812193happen__
happened1635653happened
haptenes133810823haptenes
haptens124511343hapten_s
impend11478793impend_
intends8239963intends
kalends1235683kalends
lagends947273lagends
lapped114320033lappe_d_
lappers113717463lappe_rs
lappets11329123lappe_ts
legends936073legends
lends65326253__lends
lippens11328533lippen_s
mapped134015883mappe_d_
mappers133313783mappe_rs
mappings15296413mappings
mends84927693__mends
mopeds11499663mope_ds
napped114218163nappe_d_
nappers114214863nappe_rs
nappes104515623nappe__s
offends14234293offends
opens76118553_open_s
papers105125323pape_rs
parents93418123parents
patens84820863paten_s
patents94815203patents
peds75835243__pe_ds
peens76428193_peen_s
pend75934533__pend_
penes75839223__penes
penis75129323__penis
pens65649643__pen_s
perpends13227743perpends
pleads94613953_pleads
poinds93511143_poinds
ponds85323403__ponds
pounds93714383_pounds
propends13249173propends
pseuds944793_pseuds
rapped114122683rappe_d_
rappees113611453rappe_es
rappels11448803rappe_ls
rappen103512713rappen__
rappers113618443rappe_rs
relends84013253relends
remends105013033remends
rends65129953__rends
repents93717623repents
resends83513713resends
ripens85012173ripen_s
sapheads1466083sapheads
saphenas1345713saphenas
sapiens9310173sapien_s
sapients1037423sapients
sapped114422013sappe_d_
sappers113518903sappe_rs
scends95213003_scends
sends65528243__sends
shends105313773_shends
speeds94316053_speeds
spend85619333_spend_
spendy124911143_spendy
sphenes123013163sphenes
splents93912133splents
spreads1039763spreads
stipends11304793stipends
suspends1145143suspends
tapped113820053tappe_d_
tappers113416543tappe_rs
tappets113610013tappe_ts
tappings13267713tappings
tends65425583__tends
trends75513543_trends
unbends10236993unbends
unpens82511013unpen_s
upbinds12234813upbinds
upend85011043_upend_
uplands1036943uplands
upped103715163uppe_d_
uppers102912293uppe_rs
uppings12257123uppings
upsend9356883upsend_
uptrends1142833uptrends
upwinds13224223upwinds
vends95520893__vends
wapped144416473wappe_d_
wends95822813__wends
yapped144415143yappe_d_
yappers144012253yappe_rs
zapped204213523zappe_d_
zappers203911633zappe_rs

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.1401276364.3
2DLD Change Limit1340272197.28018410.3
3Display Results2192190.0802737.5
 (SQL Overall)1786912197.50023825.5
 
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.