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

223 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
context16391343(None) 
content94326151content
contest93523231contest
contexts17378651contexts
conceit113218072conceit
concent114422512concent
concept133314442concept
concert113325222concert
confect143614272confect
congest104618772congest
connect113515742connect
consent93723112consent
contact1144020682contact
conte76633202conte__
contemn1137802contemn
contempt1447472contempt
contend103511892contend
contents104018212contents
contes84432912conte_s
contests103413382contests
contort91422342contort
convect143114482convect
convent123919412convent
convert123721472convert
convex18367742convex_
cortex15311472cortex_
boniest93318993boniest
bonnet85524633bonne_t
candent10417363candent
canted94825783cante_d
canteen9411083canteen
canter85230113cante_r
canters94827733canters
center84421413cente_r
centers94420603centers
coagent10313983coagent
coannex1635513coannex_
coated94927043coate_d
coatee84327223coate_e
coatees93816553coatees
coater84329573coate_r
coaters93525793coaters
coattest1038863coattest
codex155817583co_dex_
coerect11913353coerect
coexert16312363coexert
cogent9321003co_gent
coinfect15276843coinfect
cointer93616723cointe_r
cointers103616413cointers
coinvent1348183coinvent
coldest102514763coldest
collect113314593collect
collet84030363colle_t
colter84625093colte_r
colters93522443colters
comet95946073co_me_t
comment1310317703comment
commixt20357623commixt
comte96125473comte__
comtes106222813comte_s
conceal113313013conceal
concede12310103concede
conceits122813613conceits
concents122516603concents
concepti14328273concepti
concepts143110303concepts
concern113011963concern
concerti122912603concerti
concerto123311613concerto
concerts123016063concerts
concoct10312903concoct
condemn1237113condemn
conduct121411593conduct
conduit10713083conduit
cone67256963con_e__
coned86040053con_e_d
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confects153110873confects
confer114018683confe_r
confers124120093confers
confess12399903confess
confetti1345993confetti
confetto1346253confetto
confit113316403con_fit
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congeed113212313congeed
congees103517923congees
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congests113510383congests
conies84338593conie_s
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
connects123010563connects
conned95119703conne_d
conner84423963conne_r
conners94023113conners
conquest1939553conquest
consents102715893consents
consist9316033consist
consort91319903consort
constant10515593constant
consult92513633consult
contacts123215213contacts
contain9315833contain
contemns1237403contemns
contempo1444833contempo
contempts1545063contempts
contends112810573contends
contented12313043contented
contessa1044583contessa
contested12310693contested
contester11311183contester
contextual1954353contextual
contexture1943933contexture
continent11415633continent
conto76027173cont__o
contorts101112643contorts
contos84923233cont_os
contour939973contour
contra83314703cont_ra
contract122915633contract
contras93015623contras
contrast102614783contrast
contrite10318543contrite
control9310693control
contuse9311413contuse
convects153410993convects
convene123314323convene
convents132614603convents
converts133213553converts
convexes20278273convexes
convexity2443313convexity
convexly2343783convexly
convey144610223conve_y
conveys15308223conveys
convict143410983convict
coolest9318643coolest
cooter85128613coote_r
cooters94525723cooters
copter109822013copte_r
copters113621283copters
coquet174318013coque_t
cornet84436733corne_t
corniest102117303corniest
correct11513983correct
corset85636223corse_t
cortege1098953cortege
cortexes1797613cortexes
corvet114626933corve_t
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
costed95623113coste_d
coster84331293coste_r
costers94128333costers
cote66648733co_te__
coteau8311083co_teau
coted85033853co_te_d
cotes76347843co_te_s
cotter84926673cotte_r
cotters94323443cotters
counted103815803counte_d
counter94220153counte_r
counters103320193counters
countess103710053countess
couteau938833couteau
couter84930223coute_r
couters93827303couters
couthest13312083couthest
covert114925503co_vert
covet105638943co_ve_t
cowiest123614673cowiest
coyest11316053co_yest
coziest184014353coziest
curtest9713963curtest
cutest85820143c_utest
donnert82815533donnert
fondest11312403fondest
honest94822423hon_est
hottest10411383hottest
intent63122773_intent
longest84114953longest
monte75829773monte__
monteith1375793monteith
montero9310133montero
montes84226933monte_s
mostest9314793mostest
motet75641193mo_te_t
next116631083__n_ext
nonet54540843non_e_t
nonmeat9312773nonmeat
nontax1348413nontax_
obtect10129633_obtect
obtest81213013_obtest
octet7324063_octe_t
oftest91212003_oftest
oncet74626543_once_t
onset54730173_onse_t
outeat62824533_outeat
ponent82821593pon_ent
pontes83627853ponte_s
portent93619643portent
potent84223353po_tent
pretext1639663pretext
scantest101710183scantest
softest10310603softest
sonnet65923503sonne_t
subtext1647653subtext
text116033933___text
toniest73218903toniest
tonlet62924703tonle_t
unvext1658173_unvext
urtext1337433_urtext
vortex1635923vortex_
wonted103213283wonte_d

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.406440125.6
2DLD Change Limit1340272236.79619721.5
3Display Results2232230.0762934.2
 (SQL Overall)1786912237.27824552.2
 
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.