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

433 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
contend10351189(None) 
contends112810571contends
content94326151content
canted94825782cante_d
coated94927042coate_d
coattend1134652coattend
coextend1842482coextend
commend144010182commend
compend144010302compend
concent114422512concent
coned86040052con_e_d
congeed113212312congeed
conked135019112conke_d
conned95119702conne_d
consent93723112consent
conte76633202conte__
contemn1137802contemn
contemned1446792contemned
contemns1237402contemns
contended1339272contended
contender1239562contender
contented12313042contented
contents104018212contents
contes84432912conte_s
contest93523232contest
context163913432context
convene123314322convene
convened143412222convened
convent123919412convent
costed95623112coste_d
coted85033852co_te_d
counted103815802counte_d
intend72310372_intend
portend103411192portend
wonted103213282wonte_d
anted66328243_ante_d
anteed75616113_anteed
attend7258973_attend
banteng1046363banteng
bartend1038753bartend
boated94221973boate_d
bolted94617803bolte_d
bonded104719953bonde_d
boned85133243bon_e_d
bonged105719603bonge_d
bonked135517313bonke_d
bookend14396643bookend
booted94822733boote_d
bunted95219183bunte_d
candent10417363candent
caned85838093can_e_d
canned95022063canne_d
canoed94618963canoe_d
canteen9411083canteen
canteens1038573canteens
canter85230113cante_r
cantered113415983cantered
canters94827733canters
cantina93417253cantina
canting104725903canting
canton85722993canton_
cantoned111411523cantoned
cantons95221203cantons
carted98631443carte_d
catena8312483c_atena
catted95422473catte_d
censed94016323cense_d
center84421413cente_r
centered112513523centered
centers94420603centers
centner946853centner
centred103411683centred
chanted134015953chante_d
chorten122811303chorten_
chortens13308793chortens
chuted124611843chute_d
cisted95217523ciste_d
cited84421953c_ite_d
cloned94518803clon_e_d
clonked14429563clonke_d
clotted104011823clotte_d
clouted104212163cloute_d
coacted123611613coacte_d
coagent10313983coagent
coaled95022713coale_d
coapted123911503coapte_d
coasted104015953coaste_d
coatee84327223coate_e
coatees93816553coatees
coater84329573coate_r
coaters93525793coaters
coating103525313coating
coattends1243913coattends
coaxed165612513coaxe_d
cocked155022563cocke_d
codded114515303codde_d
coded95433183co_de_d
coden86128543co_den_
codens94821013co_dens
coed77140543co__e_d
coextends1942323coextends
cofound1335513cofound
cogent9321003co_gent
cogged116416613cogge_d
cohead123811123co_head
coifed124113063coife_d
coigned11418663coigned
coiled95123943coile_d
coined94523603coine_d
cointer93616723cointe_r
cointers103616413cointers
coinvent1348183coinvent
coked124730693co_ke_d
colead94114643co_lead
coled85540763co_le_d
colter84625093colte_r
colters93522443colters
combed135516543combe_d
command14399213command
commends15308463commends
comment1310317703comment
comped135919873compe_d
compends15378253compends
compted143813523compte_d
comte96125473comte__
comtes106222813comte_s
conceal113313013conceal
concede12310103concede
conceded1438293conceded
conceit113218073conceit
concents122516603concents
concept133314443concept
concern113011963concern
concerned1438643concerned
concerns122710833concerns
concert113325223concert
concord12510343concord
condemn1237113condemn
condemned1545103condemned
condemns1336293condemns
condense1179613condense
condensed1387113condensed
condone102616293condone
condoned122612023condoned
cone67256963con_e__
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confect143614273confect
confer114018683confe_r
confers124120093confers
confess12399903confess
confine12315583confine
confined14310403confined
confound1445903confound
confuted1437683confute_d
congaed11399743congaed
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congees103517923congees
congener112412203congener
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congest104618773congest
conies84338593conie_s
coniine9316803coniine
conin76232723con_in_
conine84528553con_ine
conines93827793conines
coning94331823con_ing
conins84327233con_ins
conker124721553conke_r
conkers133721043conkers
conking143618453conking
conn66229133con__n_
connect113515743connect
conner84423963conne_r
conners94023113conners
conning103718753conning
connoted1138863connote_d
conns75024233con__ns
conoid9818883con_oid
consented12311943consented
consents102715893consents
constant10515593constant
contact1144020683contact
contain9315833contain
contained12310893contained
contains10316533contains
contemner1347183contemner
contemnor1344643contemnor
contempo1444833contempo
contempt1447473contempt
contenders1348623contenders
contending1449123contending
contessa1044583contessa
contested12310693contested
contests103413383contests
contexts17378653contexts
continent11415633continent
continua1047653continua
continue10311123continue
continued1248483continued
continuo1047353continuo
conto76027173cont__o
contort91422343contort
contos84923233cont_os
contour939973contour
contra83314703cont_ra
contras93015623contras
control9310693control
contuse9311413contuse
contused1138443contused
convect143114483convect
convener132913163convener
convenes132916913convenes
convenor13307613convenor
convented15410753convented
convents132614603convents
convert123721473convert
convex18367743conve_x
convey144610223conve_y
conveyed17247923conveyed
conveys15308223conveys
cooed84534343co_oe_d
cooeed95917863co_oeed
cooked135921363cooke_d
cooled95224593coole_d
cooped114821603coope_d
coopted123710763coopte_d
cooter85128613coote_r
cooters94525723cooters
coped105036843co_pe_d
copen94826433co_pen_
copens106119963co_pens
copied114618563copie_d
copped135221253coppe_d
copter109822013copte_r
copters113621283copters
corded105923353corde_d
cored85044223co_re_d
corked135020783corke_d
corned95224523corne_d
cornfed1337383cornfe_d
cornuted1137473cornute_d
cortege1098953cortege
cortex15311473corte_x
cortin82423153cortin_
cortina91915973cortina
cortins92421333cortins
coshed124217543coshe_d
cosied94819883cosie_d
costard104113353costard
coster84331293coste_r
costers94128333costers
costing104323023costing
cotan71521783co_tan_
cotans81317923co_tans
cote66648733co_te__
coteau8311083co_teau
cotes76347843co_te_s
coting94629253co_ting
cotter84926673cotte_r
cottered112511733cottered
cotters94323443cotters
cotton8312993cotton_
cottoned1138033cottoned
cottons9312193cottons
cottony1237253cottony
counter94220153counte_r
countered12313003countered
counters103320193counters
countess103710053countess
counting113115273counting
couped115019313coupe_d
courted103514923courte_d
couteau938833couteau
couter84930223coute_r
couters93827303couters
coved115027373co_ve_d
coven106925043co_ven_
covens114919263co_vens
coveted133011523coveted
cowbind1536613cowbind
cowed115637853co_we_d
cowhand1665933cowhand
cowherd1636953cowherd
cowled125218393cowle_d
cowmen13810923cowmen_
coxed154322813co_xe_d
coyed114623803co_ye_d
cozen165019703co_zen_
cozened19349183co_zened
cozens176314923co_zens
cozied184112153cozie_d
crated94827773crate_d
dented84120513dente_d
dinted84419843dinte_d
distend93312073distend
doated84118183doate_d
doited85016633doite_d
donated93513863donate_d
donned85015743donne_d
donnerd9427813donnerd
doted75227073do_te_d
dotted84717523dotte_d
downtrend1442163downtrend
dunted84718503dunte_d
extend14267523_extend
fonded115717043fonde_d
fontina1038633fontina
footed104418623foote_d
forfend1435413forfend
fronted114011273fronte_d
goateed9307063goateed
godsend1084043godsend
gonged97115913gonge_d
gotten73410113gotten_
hanted104124313hante_d
hented104218753hente_d
hinted104318323hinte_d
honed95332263hon_e_d
honied104818393honie_d
honked144517913honke_d
hooted104422663hoote_d
hosted105020343hoste_d
hotted104319943hotte_d
hunted104417013hunte_d
intends8239963_intends
intent63122773_intent
jointed15378503jointe_d
jolted143510633jolte_d
jotted143615173jotte_d
konked104010583konke_d
lenten6312883lenten_
linted74021823linte_d
lofted103811893lofte_d
longed87121373longe_d
looted74421113loote_d
lotted74222403lotte_d
louted74920693loute_d
lunted74517523lunte_d
minted94220583minte_d
minuend1035383minuend
mistend103812523mistend
moated94819003moate_d
molted94217473molte_d
molten83311813molten_
monied94319463monie_d
montane91313623montane
monte75829773monte__
montero9310133montero
montes84226933monte_s
mooted94120373moote_d
mounted103611533mounte_d
nonmen8412833nonmen_
noted65123843no_te_d
oaten55222403_oaten_
obtund945583_obtund
offend13365663_offend
often84611413_often_
opted84914273_opte_d
outed65429063_oute_d
panted95024823pante_d
pentene9313793pentene
pointed103813983pointe_d
ponced114314813ponce_d
ponded105218773ponde_d
ponent82821593pon_ent
ponged105619353ponge_d
ponied94920703ponie_d
pontes83627853ponte_s
pontine92419053pontine
ponton83217643ponton_
pontons93315553pontons
ported94223243porte_d
portends11358963portends
portent93619643portent
posted93722493poste_d
potent84223353po_tent
potted94624013potte_d
pouted94021393poute_d
pretend104011013pretend
protend104012793protend
punted94618713punte_d
ranted74324703rante_d
rented74426593rente_d
rontgen835173rontgen_
rontgens944683rontgens
rooted75424003roote_d
rotted74524433rotte_d
rotten64115433rotten_
rotund737293ro_tund
routed75624333route_d
scanted104114393scante_d
scented102811883scente_d
sconced12359173sconce_d
scooted103612283scoote_d
scouted104112033scoute_d
soften9429493soften_
softened1235663softened
softens10347623softens
sooted73922593soote_d
sorted74523713sorte_d
sotted74121403sotte_d
subtend1037103subtend
tend56433773___tend
tented74221003tente_d
tinted74419533tinte_d
toited74016753toite_d
toned65435343ton_e_d
tonged86518903tonge_d
tontine72316143tontine
tooted74620123toote_d
torten65314353torten_
toted64929483to_te_d
totted74319953totte_d
touted74419743toute_d
unbend9269773_unbend
unkend11309223_unkend
vented104617923vente_d
voted93919143vo_te_d
wanted104319723wante_d
wonned104012063wonne_d
wonting113214103wonting
wonton93410963wonton_
wontons103310533wontons
wotted104115713wotte_d
zonated173310533zonate_d
zoned154020263zon_e_d
zonked20429473zonke_d

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.1561145455.1
2DLD Change Limit1340274336.59320328.7
3Display Results4334330.1403092.9
 (SQL Overall)1786914336.88925938.6
 
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.