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

294 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
cognate1031220(None) 
cognates11311581cognates
connate9315751connate
agnate73314882_agnate
cogitate1148552cogitate
cognac1157272cogna_c
cognacs1256042cognacs
cognately1543852cognately
cognise1059682cognise
cognize1957682cognize
coinage10310552coinage
coinmate1239062coinmate
collate92919682collate
comate104124842co_mate
connote9311612connote
conte76633202co_n_te
cordate10315222cordate
cornute939642cornute
coronate103018212coronate
costate94019272costate
crenate93317112crenate
cyanate12259702cyanate
donate73619502do_nate
magnate10512702magnate
ornate6315142_ornate
togate74515682tog_ate
zonate154114922zo_nate
aconite9315473aco_nite
adnate72913483_adnate
agate66525153_ag_ate
agnates82813193_agnates
alginate9310693alginate
binate8419773_binate
borate85026153bo_rate
bornite9311183bornite
canape10913523c_anape
carate84734003c_arate
carinate103320253carinate
carnage10311743carnage
caseate9314783caseate
cate66254603c___ate
catenate10312833catenate
caudate10311353caudate
cenote83715843c_enote
cerate84829463c_erate
chelate122914903chelate
choanae1236863choana_e
cholate122114933cholate
chordate1448033chordate
ciliate9514603ciliate
cirrate92413493cirrate
citrate92216803citrate
clavate1238713clavate
climate11312833climate
clodpate1344083clodpate
coadunate1245643coadunate
coagulate1258083coagulate
coat67558353co__at_
coated94927043co__ated
coatee84327223co__atee
coater84329573co__ater
coati75624643co__ati
coats75635003co__ats
cobnut10311323cobnut_
cobnuts1135353cobnuts
cockade1638133cockade
cocotte1138603cocotte
cocreate122611813cocreate
coenact11311803coenact
coenacted1445803coenacted
coenacts1246403coenacts
coenure968153coenure
coequate1946153coequate
coesite9713623coesite
cogent9321003cogent_
cogitated1346323cogitated
cogitates1247863cogitates
cogito939203cog_ito
cognation12310753cognation
cognised1256313cognised
cognises11610043cognises
cognitive1545483cognitive
cognized2136293cognized
cognizer2055863cognizer
cognizes2058033cognizes
cognomen1346083cognomen
cogway1566183cogwa_y
cogways1634633cogways
cohobate1547013cohobate
coigne94612193coign__e
coinable12311583coinable
coinages11310803coinages
coinmates1348343coinmates
cointer93616723coin_ter
collage102813763collage
collated113615063collated
collates103019143collates
colocate12313443colocate
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comanage1346343comanage
comates114123643co_mates
combat12316753combat_
combated1539823combated
combater1439383combater
combats13311683combats
commata1338483commata
commute134310443commute
compare135814993compare
compete134716553compete
compote135616463compote
compute134513663compute
comrade12139213comrade
comte96125473co__mte
conative131214623co_native
conatus9310463co_natus
concave1439373concave
cone67256963co_n__e
conepate12712533conepate
conflate13311173conflate
confute1239263confute
conga85419873conga__
congaed11399743congaed
congas94417033conga_s
conge85227593co_n_ge
congee96024473co_ngee
congrats11311433congrats
conine84528553co_nine
connately1445233connately
connive1238993connive
connoted1138863connoted
connotes10311453connotes
contes84432913co_n_tes
conto76027173co_n_to
coontie9311423coontie
copemate1439993copemate
copulate122614113copulate
coranto9311893coranto
cordage11310063cordage
cordite10315263cordite
corelate10516013corelate
corkage1438373corkage
corncake1645263corncake
cornet84436733cornet_
cornets94820573cornets
cornice11612933cornice
cornuted1137473cornuted
cornuto937033cornuto
coronae94214893corona_e
coronated123313323coronated
coronates1110816923coronates
corotate102813933corotate
corrade101111043corrade
corsage1039803corsage
costae85319683costa_e
cote66648733co___te
cottae84615703cotta_e
cottage104210573cottage
count74932053coun_t_
counted103815803coun_ted
counter94220153coun_ter
counts84618273coun_ts
county114313323coun_ty
courage10310993courage
courante1049953courante
couvade1335063couvade
cowage12310673co_wage
cowbane1437673cowbane
cowhage1636303cowhage
cowpat13312033cowpat_
cowpats1437713cowpats
cowrite123612683cowrite
cowrote12289673cowrote
coxae146115183co_xa_e
coyote11411783co_yote
cozenage2094793cozenage
craniate10312563craniate
crate76537403c__rate
create85126383c_reate
cremate113816183cremate
crenated113013913crenated
crinite9513633crinite
cuneate9311723cuneate
curate85226243c_urate
curtate9312643curtate
cuspate1138233cuspate
cyanates13238433cyanates
cyanite122710763cyanite
cygnet1237893cygnet_
cygnets1333813cygnets
dogbane1135653dogbane
dogface1454053dogface
dogmata1145143dogmata
dognap1035343dogna_p
dognaped1343493dognaped
dognaper1243693dognaper
dognaps1134393dognaps
dogvane1243853dogvane
dominate11312853dominate
donated93513863do_nated
donates83217223do_nates
echinate1359403echinate
elongate945613elongate
emanate9312473emanate
enate54428153__enate
ergate7315143erg_ate
foggage1334113foggage
folate93320393fo_late
foliate10513533foliate
formate123115093formate
fossate10388603fossate
foveate1338363foveate
gate55746573__g_ate
gnat56034433__gnat_
gnats65217713__gnats
grate64932883__grate
hogmane1336343hogmane
hognose11117243hognose
hognut1039413hognut_
hognuts1134183hognuts
ignite71410583_ignite
ingate73018243ing_ate
ingrate8715123ingrate
innate63917313_innate
iodate7313503io_date
iodinate949343iodinate
jobname1842933jobname
jugate14379463jug_ate
khanate1437073khanate
lanate6421263_lanate
legate72917453leg_ate
ligate72519253lig_ate
lignite81310303lignite
lobate82915243lo_bate
locate83919843lo_cate
loggats9286453loggats
lunate6316043_lunate
magnates11511613magnates
migrate101314173migrate
monte75829773mo_n_te
negate72915573neg_ate
neonate7311333neonate
nominate10312473nominate
nonage7313683no_nage
nongame1038183nongame
notate63217863no_tate
oblate82214743_oblate
ocreate93711743ocreate
odonate848403odonate
oleate6318883_oleate
opiate8513463_opiate
orate55133303_o_rate
outate62923403_outate
ovate84214393_o_vate
ozonate1646863ozonate
paginate114012443paginate
pennate93314033pennate
phenate12412203phenate
phonate12411813phonate
pinnate93613743pinnate
planate9314573planate
pointe84619313poin_te
pronate9418873pronate
quinate16511573quinate
regrate82618663regrate
roseate7613453roseate
rotate63320343ro_tate
rugate75813813rug_ate
ruinate7312833ruinate
senate63725173_senate
shogunate1342853shogunate
sigmate10710143sigmate
signage937773signage
solate64526073so_late
solvate102710213solvate
sonata6313223so_nata
sorbate9311733sorbate
spinate93114813spinate
stagnate947243stagnate
tannate71813523tannate
ternate7415483ternate
toccate1138773toccate
togae67020113tog_a_e
togated94410663tog_ated
toluate7159343toluate
tonnage8168053tonnage
unornate848013unornate
urinate7315363urinate
vaginate123911083vaginate
volante1038513volante
volvate13317993volvate
zonae145116443zo_na_e
zonated173310533zo_nated

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.423422437.4
2DLD Change Limit1340272948.06316622.5
3Display Results2942940.1232390.2
 (SQL Overall)1786912948.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.