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

165 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
contexts1737865(None) 
contents104018211contents
contests103413381contests
context163913431context_
conceits122813612conceits
concents122516602concents
concepts143110302concepts
concerts123016062concerts
confects153110872confects
congests113510382congests
connects123010562connects
consents102715892consents
contacts123215212contacts
contemns1237402contemns
contempts1545062contempts
contends112810572contends
content94326152content_
contes84432912conte__s
contest93523232contest_
contorts101112632contorts
convects153410992convects
convents132614602convents
converts133213552converts
convexes20278272convexes
cortexes1797612cortexes
bonnets94812803bonne_ts
canteens1038573canteens
canters94827723cante_rs
centers94420593cente_rs
centeses1079443centeses
centesis1058143centesis
coagents1138443coagents
coannexes1843643coannexes
coatees93816533coate_es
coaters93525773coate_rs
coattests1143453coattests
coerects1258543coerects
coexerts1734883coexerts
coinfects16344573coinfects
cointers103616403cointe_rs
coinvents1445663coinvents
collects12279783collects
collets93517903colle_ts
colters93522433colte_rs
comets105823583co_me_ts
comments142913873comments
comtes106222813comte__s
conceals123111013conceals
concedes13311053concedes
conceit113218073conceit_
concent114422513concent_
concept133314443concept_
concepti14328253concepti
conceptus15295863conceptus
concerns122710833concerns
concert113325223concert_
concerti122912593concerti
concerto123311613concerto
concertos132711123concertos
concocts1138633concocts
condemns1336293condemns
conducts13118703conducts
conduits111210053conduits
cones76457423con_e__s
coneys115218423con_e_ys
confect143614273confect_
confers124120093confe_rs
confess12399903confe_ss
confetti1345983confetti
confetto1346253confetto
confits122811423con_fits
congeals11309853congeals
congees103517923conge_es
congers104223233conge_rs
conges94928173conge__s
congest104618773congest_
congrats11311433congrats
conies84338593conie__s
conkers133721043conke_rs
connect113515743connect_
conners94023113conne_rs
conquests2045363conquests
consent93723113consent_
consists10310593consists
consorts101512333consorts
constants11410913constants
consults10219983consults
contact1144020683contact_
contains10316533contains
conte76633203conte___
contemn1137803conte_mn
contempo1444833contempo
contempt1447473contempt
contend103511893conte_nd
contented12313043contented
contessa1044583contessa
contessas1145023contessas
contested12310693contested
contester11311183contester
contesters12410183contesters
contextless2052483contextless
contextual1954333contextual
contexture1943933contexture
contextures2054123contextures
continents1249563continents
contort91422343contort_
contos84923233cont__os
contours1039613contours
contracts132212003contracts
contras93015603cont_ras
contrast102614783contrast
contrasts112211033contrasts
contrite10318523contrite
controls10311393controls
contuses10413453contuses
convect143114483convect_
convenes132916913convenes
convent123919413convent_
convert123721473convert_
convex18367743convex__
convexity2443313convexity
convexly2343783convexly
conveys15308223conve_ys
convicts15337713convicts
cooters94525713coote_rs
copters113621273copte_rs
coquets18399893coque_ts
cornets94820573corne_ts
corrects1259573corrects
corsets94819803corse_ts
corteges1198813corteges
cortex15311463cortex__
corvets124715023corve_ts
cosets85824403co_se_ts
cossets95014283cosse_ts
costers94128303coste_rs
cotes76347843co_te__s
cotters94323433cotte_rs
counters103320183counte_rs
countess103710043counte_ss
couters93827283coute_rs
coverts124813813co_verts
covets114819643co_ve_ts
intents72115703_intents
monteith1375793monteith
monteiths1473543monteiths
monteros1039433monteros
montes84226933monte__s
mostests1036833mostests
motets84216193mo_te_ts
nonets64118703non_e_ts
nontaxes1537853nontaxes
obtests9136233_obtests
octets839403_octe_ts
onsets64013543_onse_ts
outeats72215703_outeats
pontes83627853ponte__s
portents103512823portents
pretexts1735603pretexts
sonnets74211993sonne_ts
subtexts1744903subtexts
texts125515043___texts
tonlets73212503tonle_ts
urtexts1433143_urtexts
vortexes18114043vortexes

Search took 10 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.1731032896.0
2DLD Change Limit1461621659.20315882.0
3Display Results1651650.1401178.6
 (SQL Overall)1786911659.51618778.0
 
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.