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

198 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
contends11281057(None) 
contend103511891contend_
contents104018211contents
coattends1243912coattends
coextends1942322coextends
commends15308462commends
compends15378252compends
concents122516602concents
consents102715892consents
contemns1237402contemns
contended1339272contended
contender1239562contender
contenders1348622contenders
content94326152conten_t
contes84432912conte__s
contests103413382contests
contexts17378652contexts
convenes132916912convenes
convents132614602convents
intends8239962_intends
portends11358962portends
attends8257593_attends
bantengs1134593bantengs
bartends1136793bartends
bookends15374853bookends
calends1039523c_alends
canted94825783cante_d_
canteens1038573canteens
canters94827733cante_rs
cantinas102713773cantinas
cantons95221203canton_s
catenas9313113c_atenas
centers94420603cente_rs
centeses1079443centeses
centesis1058143centesis
centners1057243centners
centones10313663centones
chortens13308793chorten_s
coagents1138453coagents
coated94927043coate_d_
coatees93816553coate_es
coaters93525793coate_rs
coatings113811843coatings
coattend1134653coattend_
codens94821013co_den_s
coeds85920163co__e_ds
coextend1842483coextend_
cofounds1444713cofounds
coheads13289233co_heads
cointers103616413cointe_rs
coinvents1445663coinvents
coleads102911423co_leads
colters93522443colte_rs
commands15318823commands
commend144010183commend_
comments142913883comments
compend144010303compend_
comtes106222813comte__s
conceals123111013conceals
concede12310103conce_de
concedes13311063concedes
conceits122813613conceits
concent114422513concen_t
concepts143110303concepts
concerns122710833concerns
concerts123016063concerts
concords1358593concords
condemns1336293condemns
condense1179613condense
condenses12710133condenses
condones112817393condones
coned86040053con_e_d_
conenose1078593con_enose
cones76457423con_e__s
coneys115218423con_e_ys
confects153110873confects
confers124120093confe_rs
confess12399903confe_ss
confines13315653confines
confounds1544323confounds
congeals11309853congeals
congeed113212313congeed_
congees103517923conge_es
congener112412203congener
congeners122511133congeners
congers104223233conge_rs
conges94928173conge__s
congests113510383congests
conies84338593conie__s
coniines10415363coniines
conines93827793con_ines
conins84327233con_in_s
conked135019113conke_d_
conkers133721043conke_rs
connects123010563connects
conned95119703conne_d_
conners94023113conne_rs
conns75024233con__n_s
conoids10813883con_oids
consensus1144923consensus
consent93723113consen_t
constants11410913constants
contacts123215213contacts
contains10316533contains
conte76633203conte___
contemn1137803conte_mn
contemned1446793contemned
contemner1347183contemner
contemners1447073contemners
contemnor1344643contemnor
contemnors1445243contemnors
contempo1444833contempo
contempt1447473contempt
contempts1545063contempts
contending1449123contending
contented12313043contented
contessa1044583contessa
contessas1145023contessas
contest93523233conte_st
context163913433conte_xt
continents1249563continents
continua1047653continua
continue10311123continue
continues11310993continues
continuo1047353continuo
continuos1147003continuos
contorts101112643contorts
contos84923233cont__os
contours1039653contours
contras93015623cont_ras
controls10311393controls
contuses10413453contuses
convects153410993convects
convene123314323conven_e
convened143412223convened
convener132913163convener
conveners142911443conveners
convenor13307613convenor
convenors14277633convenors
convent123919413conven_t
converts133213553converts
convexes20278273convexes
conveys15308223conve_ys
cooters94525723coote_rs
copens106119963co_pen_s
copters113621283copte_rs
corteges1198823corteges
cortexes1797613cortexes
cortinas102212443cortinas
cortins92421333cortin_s
costards113510793costards
costed95623113coste_d_
costers94128333coste_rs
cotans81317923co_tan_s
coted85033853co_te_d_
cotes76347843co_te__s
cotters94323443cotte_rs
cottons9312193cotton_s
counted103815803counte_d_
counters103320193counte_rs
countess103710053counte_ss
couters93827303coute_rs
covens114919263co_ven_s
cowbinds1634453cowbinds
cowhands1765263cowhands
cowherds1735423cowherds
cozens176314923co_zen_s
distends10339823distends
downtrends1551473downtrends
extends15227113_extends
fontinas1136853fontinas
forfends1544833forfends
frontenis1243423frontenis
godsends11113353godsends
intend72310373_intend_
intents72115703_intents
minuends1143893minuends
mistends11419593mistends
montanes101114523montanes
monteros1039453monteros
montes84226933monte__s
obtunds1033763_obtunds
offends14234293_offends
pentenes10315633pentenes
pontes83627853ponte__s
pontons93315553ponton_s
portend103411193portend_
portents103512823portents
pretends11299113pretends
protends113010353protends
rontgens944683rontgen_s
softens10347623soften_s
subtends1136173subtends
tends65425583___tends
tontines82114733tontines
unbends10236993_unbends
wonted103213283wonte_d_
wontons103310533wonton_s

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621987.34319904.9
3Display Results1981980.0762605.3
 (SQL Overall)1786911987.84222786.4
 
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.