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

391 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
content9432615(None) 
concent114422511concent
consent93723111consent
contend103511891contend
contents104018211contents
contest93523231contest
context163913431context
convent123919411convent
candent10417362candent
coagent10313982coagent
cogent9321002co_gent
coinvent1348182coinvent
comment1310317702comment
conceit113218072conceit
concents122516602concents
concept133314442concept
concert113325222concert
confect143614272confect
congest104618772congest
connect113515742connect
consents102715892consents
constant10515592constant
contact1144020682contact
conte76633202conte__
contemn1137802contemn
contemns1237402contemns
contempt1447472contempt
contends112810572contends
contented12313042contented
contes84432912conte_s
contests103413382contests
contexts17378652contexts
continent11415632continent
contort91422342contort
convect143114482convect
convene123314322convene
convents132614602convents
convert123721472convert
intent63122772_intent
ponent82821592pon_ent
portent93619642portent
potent84223352po_tent
anent54931843_an_ent
attent62818323_attent
banteng1046363banteng
boniest93318993boniest
bonnet85524633bonne_t
cadent94120363c_adent
canted94825783cante_d
canteen9411083canteen
canteens1038573canteens
canter85230113cante_r
canters94827733canters
cantina93417253cantina
canting104725903canting
canton85722993canton_
cantons95221203cantons
catena8312483c_atena
cement103321663c_ement
cent67451013c___ent
center84421413cente_r
centers94420603centers
centner946853centner
cholent12313253cholent
chorten122811303chorten_
chortens13308793chortens
clement11313773clement
client8316343c_lient
coagents1138453coagents
coated94927043coate_d
coatee84327223coate_e
coatees93816553coatees
coater84329573coate_r
coaters93525793coaters
coating103525313coating
coattend1134653coattend
coattest1038863coattest
coden86128543co_den_
codens94821013co_dens
coerect11913353coerect
coexert16312363coexert
coextend1842483coextend
coherent13412473coherent
coinfect15276843coinfect
cointer93616723cointe_r
cointers103616413cointers
coinvents1445663coinvents
coldest102514763coldest
collect113314593collect
collet84030363colle_t
colter84625093colte_r
colters93522443colters
comet95946073co_me_t
commend144010183commend
comments142913883comments
compend144010303compend
competent15411253competent
comte96125473comte__
comtes106222813comte_s
conceal113313013conceal
concede12310103concede
conceits122813613conceits
concenter13312213concenter
concepti14328273concepti
concepts143110303concepts
concern113011963concern
concerns122710833concerns
concerti122912603concerti
concerto123311613concerto
concerts123016063concerts
concoct10312903concoct
condemn1237113condemn
condemns1336293condemns
condense1179613condense
condiment14410853condiment
condolent1249833condolent
condone102616293condone
conduct121411593conduct
conduit10713083conduit
cone67256963con_e__
coned86040053con_e_d
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confects153110873confects
confer114018683confe_r
confers124120093confers
confess12399903confess
confetti1345993confetti
confetto1346253confetto
confident1549383confident
confine12315583confine
confit113316403con_fit
confluent1446903confluent
confront13411603confront
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congeed113212313congeed
congees103517923congees
congener112412203congener
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congests113510383congests
congruent1247413congruent
conies84338593conie_s
coniine9316803coniine
conin76232723con_in_
conine84528553con_ine
conines93827793conines
coning94331823con_ing
conins84327233con_ins
conjoint17410373conjoint
conjunct1945483conjunct
conjunto1744653conjunto
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
conking143618453conking
conn66229133con__n_
connects123010563connects
conned95119703conne_d
conner84423963conne_r
conners94023113conners
conning103718753conning
connivent1447723connivent
conns75024233con__ns
conodont11411153conodont
conquest1939553conquest
consented12311943consented
consenter11312493consenter
consist9316033consist
consistent1248553consistent
consort91319903consort
constants11410913constants
consult92513633consult
contacts123215213contacts
contain9315833contain
contains10316533contains
contemned1446793contemned
contemner1347183contemner
contemnor1344643contemnor
contempo1444833contempo
contempts1545063contempts
contended1339273contended
contender1239563contender
contenting13313323contenting
contention12412223contention
contessa1044583contessa
contestant1269933contestant
contested12310693contested
contester11311183contester
continents1249563continents
contingent1349083contingent
continua1047653continua
continue10311123continue
continuo1047353continuo
conto76027173cont__o
contorts101112643contorts
contos84923233cont_os
contour939973contour
contra83314703cont_ra
contract122915633contract
contras93015623contras
contrast102614783contrast
contrite10318543contrite
control9310693control
contuse9311413contuse
convects153410993convects
convened143412223convened
convener132913163convener
convenes132916913convenes
convenor13307613convenor
convented15410753convented
converts133213553converts
convex18367743conve_x
convey144610223conve_y
conveys15308223conveys
convict143410983convict
coolant9316463coolant
coolest9318643coolest
cooter85128613coote_r
cooters94525723cooters
coparent12412253coparent
copen94826433co_pen_
copens106119963co_pens
copter109822013copte_r
copters113621283copters
coquet174318013coque_t
cornet84436733corne_t
corniest102117303corniest
coronet94227173coronet
correct11513983correct
corset85636223corse_t
cortege1098953cortege
cortex15311473corte_x
cortin82423153cortin_
cortina91915973cortina
cortins92421333cortins
corvet114626933corve_t
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
costed95623113coste_d
coster84331293coste_r
costers94128333costers
costing104323023costing
cotan71521783co_tan_
cotangent1246833cotangent
cotans81317923co_tans
cote66648733co_te__
coteau8311083co_teau
coted85033853co_te_d
cotenant10511793co_tenant
cotes76347843co_te_s
coting94629253co_ting
cotter84926673cotte_r
cotters94323443cotters
cotton8312993cotton_
cottons9312193cottons
cottony1237253cottony
count74932053co__unt
counted103815803counte_d
counter94220153counte_r
counters103320193counters
countess103710053countess
counting113115273counting
courant9317973courant
couteau938833couteau
couter84930223coute_r
couters93827303couters
couthest13312083couthest
covalent1349223covalent
coven106925043co_ven_
covens114919263co_vens
covert114925503co_vert
covet105638943co_ve_t
cowiest123614673cowiest
cowmen13810923cowmen_
coyest11316053co_yest
cozen165019703co_zen_
cozens176314923co_zens
coziest184014353coziest
credent10313973credent
current9313693current
curtest9713963curtest
cutest85820143c_utest
detent73624483_detent
discontent13410253discontent
distent84120853distent
docent92918683do_cent
donnert82815533donnert
entente7412953_entente
extent132714913_extent
foment113718303fo_ment
fondant11311143fondant
fondest11312403fondest
fontina1038633fontina
fornent10312933fornent
forwent13310533forwent
gotten73410113gotten_
honest94822423hon_est
horrent10313553horrent
hottest10411383hottest
incent83320723_incent
indent73021243_indent
intend72310373_intend
intents72115703_intents
invent93316363_invent
latent64124303_latent
lenient7313843lenient
lenten6312883lenten_
loment84021473lo_ment
longest84114953longest
malcontent14124483malcontent
molten83311813molten_
moment103319683mo_ment
monotint10413713monotint
montane91313623montane
monte75829773monte__
monteith1375793monteith
montero9310133montero
montes84226933monte_s
monument1289903monument
mordent10313993mordent
mostest9314793mostest
motet75641193mo_te_t
nocent83217413no_cent
nonet54540843non_e_t
nonevent11410163nonevent
nonmeat9312773nonmeat
nonmen8412833nonmen_
oaten55222403_oaten_
obtect10129633_obtect
obtest81213013_obtest
octant81216553_octant
octet7324063_octe_t
often84611413_often_
oftest91212003_oftest
ointment1069233ointment
oncet74626543_once_t
onset54730173_onse_t
orient6322533_orient
outeat62824533_outeat
outwent10311363_outwent
patent84524923_patent
pendent10314723pendent
penitent10413503penitent
pentene9313793pentene
pontes83627853ponte_s
pontine92419053pontine
ponton83217643ponton_
pontons93315553pontons
portend103411193portend
portents103512823portents
pungent10311233pungent
renitent8315333renitent
ringent8315153ringent
rodent7519243ro_dent
rontgen835173rontgen_
rontgens944683rontgens
rotten64115433rotten_
scandent1148493scandent
scantest101710183scantest
sentient8313633sentient
soften9429493soften_
softens10347623softens
softest10310603softest
solvent10310833solvent
sonant6621953son_ant
sonnet65923503sonne_t
sorbent92915243sorbent
stent55634513__stent
tangent8314993tangent
tent46159863___tent
toniest73218903toniest
tonlet62924703tonle_t
tontine72316143tontine
torment9316173torment
torrent7313413torrent
torten65314353torten_
unbent83216593_unbent
unkent103116053_unkent
unpent83117373_unpent
unrent63219783_unrent
unsent63820963_unsent
wonted103213283wonte_d
wonting113214103wonting
wonton93410963wonton_
wontons103310533wontons

Search took 9 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 Limit1340273917.78317220.5
3Display Results3913910.1402792.9
 (SQL Overall)1786913918.32921454.1
 
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.