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

173 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
extends1522711(None) 
expends17217081expends
extend14267521extend_
extents142610171extents
attends8257592attends
coextends1942322coextends
emends95711432e_mends
exceeds1733842exceeds
expands17195732expands
expend16247502expend_
extended17135832extended
extender16146332extender
extenders17125672extenders
extent132714912exten_t
externes1539832externes
externs1438232externs
intends8239962intends
tends65425582__tends
addends10356053addends
amends94713283_amends
appends1236393appends
ascends10388203ascends
attend7258973attend_
augends935883augends
axseeds1533393axseeds
bartends1136793bartends
bends85628973__bends
besteads11307123besteads
blends96012883_blends
butenes9313033butenes
calends1039523calends
catenas9313113catenas
coextend1842483coextend_
contends112810573contends
defends12358773defends
depends11348993depends
descends12266983descends
detents83615153detents
distends10339823distends
eaten55323053eaten__
eaters65535953eate_rs
eatings84616443eatings
effendi1442423effendi
effendis1542513effendis
elands74914773e_lands
eluents738703eluents
embeds11377903embe_ds
emend86214893e_mend_
ends56528523___ends
enneads834733enneads
entente7412953entente
ententes8312773ententes
enters64425643ente_rs
enwinds11255553enwinds
errands847603errands
esteems935243esteems
esters64627733este_rs
ethenes103313873ethenes
ethnos947053e_thnos
etnas54713933e_t_nas
evens84817103e_ven_s
events94814073e_vents
examens1637193examen_s
exceed1636173exceed_
excels1536663exce_ls
excepts1885203excepts
excess1546053exce_ss
execs14539723ex_e_cs
exed125420593ex_e_d_
exerts133712293ex_erts
exes116530813ex_e__s
exines135715803ex_ines
existents1644983existents
exited144712523exite_d_
exogens1536883exogen_s
exons125813343ex_on_s
expand16236573expand_
expects1866883expects
expels1547173expe_ls
expended19136543expended
expender18136843expender
expenders19145963expenders
expense16127873expense
expenses17138373expenses
experts1659063experts
expounds1843233expounds
exscinds1842533exscinds
exsects1655573exsects
exserts1467013exserts
extant132714753extan_t
extending1835853extending
extensor1543913extensor
extensors1644083extensors
extern1348473exte_rn
external1577223external
externals1666623externals
externe1438573externe
extinct1646903extinct
extincts1743473extincts
extolls1444603extolls
extols1337683ext_ols
extorts1447753extorts
extrados1645343extrados
extras13310223ext_ras
extremes1756053extremes
extrude1545013extrude
extrudes1645243extrudes
fends96324973__fends
fiends104110293_fiends
friends11396743friends
headends13326723headends
impends12376803impends
intend72310373intend_
intents72115703intents
kalends1235683kalends
ketenes114813503ketenes
lagends947273lagends
latens64620213laten_s
latents75214313latents
legends936073legends
lends65326253__lends
mends84927693__mends
mistends11419593mistends
neatens73310403neaten_s
obtunds1033763obtunds
offends14234293offends
oxters134813273oxte_rs
patens84820863paten_s
patents94815203patents
pectens11189203pecten_s
pends85527193__pends
pentenes10315633pentenes
perpends13227753perpends
portends11358963portends
pretends11299113pretends
protends113010353protends
reblends1135293reblends
relends84013253relends
remends105013033remends
rends65129953__rends
repetends1244003repetends
resends83513713resends
retenes76324623retenes
scends95213003_scends
sends65528243__sends
sextans14349263sextan_s
sextants15287383sextants
sextets1497143sexte_ts
sextons143710413sexton_s
shends105313773_shends
spends94714473_spends
stands75118053_stands
steads74116223_steads
steeds73814883_steeds
stenos63915773_stenos
stents65019453_stents
subtends1136173subtends
teds54932573__te_ds
teinds738263__teinds
tend56433773__tend_
tendu67216003__tendu
tendus75111183__tendus
tens45647413__ten_s
tents56434213__tents
trends75513543_trends
unbends10236993unbends
upends9438763_upends
upsends10265293upsends
uptrends1142833uptrends
vends95520893__vends
weekends1642733weekends
wends95822813__wends
yearends12234483yearends

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.420425454.8
2DLD Change Limit1340271736.37621020.5
3Display Results1731730.0632746.0
 (SQL Overall)1786911736.85926052.0
 
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.