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

243 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
attends825759(None) 
attend7258971attend_
addends10356052addends
amends94713282a_mends
appends1236392appends
ascends10388202ascends
attended1035762attended
attendee946402attendee
attendees1044052attendees
attender935912attender
attenders1045272attenders
attent62818322atten_t
attests7278812attests
attunes737822attunes
augends935882augends
bartends1136792bartends
battens95313262batten_s
coattends1243912coattends
extends15227112extends
fattens105111712fatten_s
intends8239962intends
lattens75014672latten_s
pattens95414922patten_s
rattens74213402ratten_s
tends65425582__tends
trends75513542_trends
abounds10217083abounds
absents93510723absents
accents113511233accents
achenes12313493achenes
acted88521733acte_d_
actings104512463actings
actins86321103actin_s
addend9458453addend_
addenda10364463addenda
advents11309473advents
afters94717073afte_rs
agenda837253a_genda
agendas936933a_gendas
agenes74720253a_genes
agents74816293a_gents
akenes104817343a_kenes
alands75418373a_lands
aliens65619213alien_s
alkenes114212753alkenes
almonds10127953almonds
alters64924223alte_rs
amend85717753a_mend_
amens75624843a_men_s
aments85219803a_ments
ands57833613a___nds
anted66328243ante_d_
anteed75616113anteed_
antenna746383antenna
antennas846403antennas
antes56334323ante__s
antings85015583antings
append1138273append_
aptness9268573aptness
arenas65021993a_renas
arenes64928393a_renes
argents84014853argents
arpens84814823arpen_s
arpents93613083arpents
artels66216233arte_ls
ascend9429733ascend_
ascents93812553ascents
aspens85013353aspen_s
assents74512223assents
asters65631603aste_rs
astounds964233astounds
ates45047923a_te__s
atmans84413963atman_s
atoned75417543atoned_
atoners75013953atoners
atones65225773a_tones
attacks13126943attacks
attains7310983attains
attaints846493attaints
attars64515313att_ars
attempt1145373attempt
attempts1243103attempts
attendant1045473attendant
attendants1143683attendants
attending11136373attending
attendings12143523attendings
attest62618613atte_st
attics84413283att_ics
attires72312953attires
attorns738443attorns
attrits7310613attrits
attune637983attun_e
attuned835173attuned
augend837633augend_
auteurs7137503auteurs
avens86419333a_ven_s
axseeds1533393axseeds
bantengs1134593bantengs
bartend1038753bartend_
batted95623653batte_d_
batten85217123batten__
battened11259573battened
battener10369393battener
batteners11238163batteners
batters94626013batte_rs
battings114010573battings
bends85628973__bends
blends96012883_blends
butenes9313033butenes
calends1039523calends
catenas9313113catenas
catheads1438123catheads
catted95422473catte_d_
coattend1134653coattend_
contends112810573contends
defends12358773defends
depends11348993depends
detents83615153detents
distends10339823distends
emends95711433_emends
ends56528523___ends
ethenes103313873ethenes
expends17217083expends
extend14267523extend_
extents142610173extents
faciends1443573faciends
fastens105511753fasten_s
fatheads1536763fatheads
fatted105419843fatte_d_
fatten94314903fatten__
fattened12268283fattened
fattener11268113fattener
fatteners12236873fatteners
fends96324973__fends
fiends104110293_fiends
flattens11357483flatten_s
friends11396743friends
haptenes133810823haptenes
haptens124511343hapten_s
hastens106214813hasten_s
hatbands1446293hatbands
hatreds11307813hatre_ds
hatted104921513hatte_d_
hatters104221523hatte_rs
impends12376803impends
intend72310373intend_
intents72115703intents
kalends1235683kalends
ketenes114813503ketenes
kittens11347583kitten_s
lagends947273lagends
lateens74210553lateen_s
latens64620213laten_s
latents75214313latents
latten65018203latten__
lattes65324203latte__s
lattins74115483lattin_s
legends936073legends
lends65326253__lends
malteds10377603malte_ds
martens93714953marten_s
matted94521413matte_d_
matters94421753matte_rs
mattes85624533matte__s
mattings11369673mattings
mattins93316143mattin_s
mattoids1196183mattoids
mends84927693__mends
mistends11419593mistends
mittens9349883mitten_s
natters73718063natte_rs
obtunds1033763obtunds
offends14234293offends
otters64021513otte_rs
patens84820863paten_s
patents94815203patents
patients1088763patients
patted94724683patte_d_
patten84418193patten__
pattened11299393pattened
patterns10439943patterns
patters94825193patte_rs
pends85527193__pends
portends11358963portends
pretends11299113pretends
protends113010353protends
rattans73411953rattan_s
ratted74923343ratte_d_
ratteens8256053ratteens
ratten64217383ratten__
rattened9218623rattened
rattener8238533rattener
ratteners9237263ratteners
ratters74422473ratte_rs
rattons73815323ratton_s
relends84013253relends
remends105013033remends
rends65129953__rends
resends83513713resends
retenes76324623retenes
sateens73710753sateen_s
scends95213003_scends
sends65528243__sends
shends105313773_shends
spends94714473_spends
stands75118053_stands
steads74116223_steads
steeds73814883_steeds
stenos63915773_stenos
stents65019453_stents
stipends11304793stipends
stounds8377823stounds
strands83711953strands
subtends1136173subtends
talents7312013talents
taters64932203tate_rs
tates55444983tate__s
tatted74920533tatte_d_
tatters74520483tatte_rs
tattings9408823tattings
tautens7317843tauten_s
teds54932573__te_ds
teens56227483_teen_s
teinds738263_teinds
tend56433773__tend_
tendu67216003__tendu
tendus75111183__tendus
tens45647413__ten_s
tents56434213__tents
thens85921833_then_s
treads74817923_treads
trend64817453_trend_
trendy10469603_trendy
tweeds10498433_tweeds
unbends10236993unbends
upends9438763_upends
upsends10265293upsends
uptrends1142833uptrends
utters63817123utte_rs
vatted104214733vatte_d_
vends95520893__vends
wends95822813__wends
yatters103914623yatte_rs

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.406440125.6
2DLD Change Limit1340272435.92022639.7
3Display Results2432430.0803037.5
 (SQL Overall)1786912436.40627894.3
 
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.