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

254 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
cognates1131158(None) 
cognate10312201cognate_
agnates82813192_agnates
cogitates1247862cogitates
cognacs1256042cogna_cs
cognately1543852cognately
cognises11610042cognises
cognizes2058032cognizes
coinages11310802coinages
coinmates1348342coinmates
collates103019142collates
comates114123642co_mates
conatus9310462co_natus
connate9315752connate_
connotes10311452connotes
contes84432912co_n_tes
coronates1110816922coronates
cyanates13238432cyanates
donates83217222do_nates
magnates11511612magnates
aconites10314353aco_nites
agates76121343_ag_ates
agnate73314883_agnate_
alginates10310123alginates
annates72415423_annates
borates94823013bo_rates
bornites10310983bornites
canapes111213083c_anapes
carates95630613c_arates
carnages11312213carnages
caseates10313713caseates
catenates11311813catenates
cates75951893c___ates
caudates11310263caudates
cenotes92814543c_enotes
cerates95428253c_erates
chelates132713853chelates
cholates132414763cholates
chordates1547683chordates
ciliates10413453ciliates
citrates102315093citrates
climates12311973climates
clodpates1444103clodpates
coagulates13137453coagulates
coated94927043co__ated
coatee84327223co__atee
coatees93816553co__atees
coater84329573co__ater
coaters93525793co__aters
coatis85122603co__atis
coats75635003co__at_s
coaxes154715633co__axes
cobnuts1135353cobnut_s
cockades1738433cockades
cocottes1238313cocottes
cocreates132611883cocreates
coenacted1445803coenacted
coenacts1246403coenacts
coenures1048683coenures
coequates2045853coequates
coesites101313093coesites
cogencies1448103cogencies
cogitate1148553cogitate_
cogitated1346323cogitated
cogitos1037613cog_itos
cognac1157273cogna__c
cognation12310753cognation
cognations1339593cognations
cognise1059683cognise_
cognised1256313cognised
cognize1957683cognize_
cognized2136293cognized
cognizer2055863cognizer
cognizers2164433cognizers
cognomen1346083cognomen
cognomens1443863cognomens
cogways1634633cogwa_ys
cohobates1646523cohobates
coignes103912153coign__es
coinage10310553coinage_
coinmate1239063coinmate_
cointer93616723coin_ter
cointers103616423coin_ters
collages113514243collages
collate92919683collate_
collated113615063collated
colocates13312853colocates
comakes154413643co_makes
comanages1446533comanages
comate104124843co_mate_
combated1539823combated
combater1439383combater
combaters1538113combaters
combats13311683combat_s
commutes143011893commutes
compares143816433compares
competes144117243competes
compotes144716513compotes
computes143914553computes
comrades13149773comrades
comtes106222813co__mtes
concaves1538913concaves
conches144019813co_nches
condoes104319203co_ndoes
conepates13912283conepates
cones76457423co_n__es
conflates14311133conflates
confutes1339843confutes
congaed11399743conga_ed
congas94417033conga__s
congees103517923co_ngees
conges94928173co_n_ges
congoes103617303co_ngoes
congrats11311433congrat_s
conies84338593co_n_ies
conines93827793co_nines
connately1445233connately
connives1339723connives
connote9311613connote_
connoted1138863connoted
conte76633203co_n_te_
contest93523233co_n_test
contos84923233co_n_tos
coonties10513803coonties
copemates1549483copemates
copulates132612463copulates
corantoes1147653corantoes
corantos10310103corantos
cordages12310113cordages
cordate10315223cordate_
cordites11314633cordites
corelates11314863corelates
corkages1539103corkages
corncakes1745013corncakes
cornets94820573cornet_s
cornices12713303cornices
cornuses10310033cornuses
cornute939643cornute_
cornuted1137473cornuted
cornutos1046053cornutos
coronate103018213coronate_
coronated123313323coronated
corotates112714283corotates
corrades111211263corrades
corsages11310363corsages
costate94019273costate_
cotes76347843co___tes
cottages113310493cottages
counted103815803coun_ted
counter94220153coun_ter
counters103320193coun_ters
countess103710053coun_tess
counties10316283counties
counts84618273coun_t_s
courages11311393courages
courantes1148883courantes
couvades1435613couvades
cowages13310943co_wages
cowbanes1537423cowbanes
cowhages1736113cowhages
cowpats1437713cowpat_s
cowrites133011593cowrites
coyotes12410703co_yotes
cozenages2194693cozenages
craniates11310653craniates
crates85736063c__rates
creates95225203c_reates
cremates124216003cremates
crenate93317113crenate_
crenated113013913crenated
crinites10612763crinites
curates95323833c_urates
cyanate12259703cyanate_
cyanites132610163cyanites
cygnets1333813cygnet_s
dogbanes1245433dogbanes
dogfaces1554143dogfaces
dognaped1343493dognaped
dognaper1243693dognaper
dognapers1343073dognapers
dognaps1134393dogna_ps
dogvanes1344303dogvanes
dominates12311743dominates
donate73619503do_nate_
donated93513863do_nated
elongates1045383elongates
emanates10311333emanates
enates64026433__enates
ergates8314493erg_ates
foggages1434213foggages
folates103218453fo_lates
foliates11412753foliates
formates132814293formates
gates65939513__g_ates
gnats65217713__gnat_s
grates75429893__grates
hogmanes1446783hogmanes
hognoses12108143hognoses
hognuts1134183hognut_s
ignites81310583_ignites
ingates82716913ing_ates
ingrates9514173ingrates
iodates8312903io_dates
iodinates1048203iodinates
jobnames1942903jobnames
khanates1535733khanates
legates82917683leg_ates
ligates82318383lig_ates
lignites9129613lignites
locates93218813lo_cates
loggats9286453loggat_s
magnate10512703magnate_
migrates111112853migrates
monades103713823mo_nades
montes84226933mo_n_tes
nates55238333___nates
negates83215843neg_ates
neonates8310063neonates
nominates11311053nominates
nonages8313843no_nages
notates72817483no_tates
oblates91913243_oblates
odonates947743odonates
oleates7417833_oleates
opiates9312143_opiates
orates64328613_o_rates
ornate6315143_ornate_
ozonates1745963ozonates
paginates123111363paginates
penates93321603_penates
phenates13611583phenates
phonates13410643phonates
pointes93216753poin_tes
pontes83627853po_n_tes
pronates10418373pronates
regrates92618403regrates
rotates72819773ro_tates
ruinates8311883ruinates
senates73322613_senates
shogunates1442893shogunates
signages1037483signages
solates73523853so_lates
solvates11249673solvates
sonatas7510293so_natas
sorbates10311103sorbates
stagnates1046733stagnates
tannates81911953tannates
togate74515683tog_ate_
togated94410663tog_ated
toluates8138903toluates
tonnages9187873tonnages
urinates8314133urinates
zonate154114923zo_nate_
zonated173310533zo_nated

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.483369960.7
2DLD Change Limit1461622549.06316127.3
3Display Results2542540.326779.1
 (SQL Overall)1786912549.87218100.8
 
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.