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

356 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
connate931575(None) 
cognate10312191cognate
connote9311611connote
cognates11311572cognates
coinage10310552coinage
coinmate1239052coinmate
collate92919682collate
comate104124842co_mate
concave1439362concave
conepate12712532conepate
conflate13311172conflate
confute1239252confute
connately1445232connately
connive1238982connive
connoted1138862connoted
connotes10311452connotes
conte76633202co_n_te
cordate10315212cordate
cornute939632cornute
coronate103018212coronate
costate94019272costate
crenate93317112crenate
cuneate9311722cuneate
cyanate12259702cyanate
donate73619502do_nate
innate63917312_innate
ornate6315132_ornate
pennate93314032pennate
pinnate93613742pinnate
tannate71813522tannate
tonnage8168052tonnage
zonate154114922zo_nate
aconite9315473aco_nite
adnate72913483_adnate
agnate73314873_agnate
annates72415423_annates
ansate64517863_ansate
binate8419773_binate
bondage1138253bondage
boniato947283boniato
bonne75124713bonn__e
bonnet85524633bonnet_
bonneted1136223bonneted
bonnets94812803bonnets
bonnie85314853bonn_ie
borate85026153bo_rate
bornite9311183bornite
canape10913513c_anape
canna75919333canna__
cannas84518403canna_s
cannie83819363cann_ie
cannot83616773cannot_
cannulate1148623cannulate
cantata93811803cantata
canulate10314543canulate
carate84734003c_arate
carinate103320243carinate
carnage10311743carnage
caseate9314783caseate
cate66254593c___ate
catenate10312833catenate
caudate10311353caudate
cenote83715843c_enote
centare93113703centare
cerate84829463c_erate
chelate122914893chelate
choanae1236863choana_e
cholate122114933cholate
chordate1448033chordate
ciliate9514593ciliate
cineaste1045743cineaste
cirrate92413483cirrate
citrate92216793citrate
clavate1238713clavate
climate11312833climate
clodpate1344083clodpate
coadunate1245633coadunate
coat67558343co__at_
coated94927033co__ated
coatee84327213co__atee
coater84329553co__ater
coati75624633co__ati
coats75634993co__ats
cobnut10311313cobnut_
cobnuts1135343cobnuts
cockade1638133cockade
cocotte1138603cocotte
cocreate122611813cocreate
coenact11311803coenact
coenacted1445803coenacted
coenacts1246403coenacts
coenure968143coenure
coequate1946153coequate
coesite9713623coesite
cogitate1148553cogitate
cognac1157273cogna_c
cognacs1256043cognacs
cognately1543843cognately
cognise1059683cognise
cognize1957683cognize
cohobate1547013cohobate
coinable12311583coinable
coinages11310803coinages
coinmates1348323coinmates
cointer93616723coin_ter
collage102813753collage
collated113615063collated
collates103019133collates
colocate12313433colocate
colonnade1243083colonnade
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comanage1346343comanage
comates114123633co_mates
combat12316753combat_
combated1539823combated
combater1439373combater
combats13311683combats
commata1338483commata
commute134310423commute
compare135814993compare
compete134716553compete
compote135616463compote
compute134513653compute
comrade12139213comrade
comte96125473co__mte
conative131214613co_native
conatus9310463co_natus
concaved1636213concaved
concaves1538893concaves
concede12310083concede
conchae143911643conchae
conchie143312663conchie
concise11314463concise
conclave1556393conclave
concrete12411083concrete
condensate1345543condensate
condole102914953condole
condone102616293condone
conduce12139223conduce
condyle13247053condyle
cone67256963co_n__e
conenose1078593conenose
conepates13912283conepates
conepatl1286703conepatl
confab1347063confa_b
confabs1435393confabs
confide13310203confide
confine12315583confine
confit113316403confit_
confits122811423confits
conflated1539333conflated
conflates14311133conflates
confuse1238853confuse
confuted1437673confuted
confuter1338503confuter
confutes1339833confutes
conga85419873conga__
congaed11399743congaed
congas94417033conga_s
conge85227593co_n_ge
congee96024463co_ngee
congrats11311433congrats
coniine9316803coniine
conine84528553co_nine
conjugate1945003conjugate
conjure16109063conjure
conn66229133conn___
connation11314263connation
connect113515743connect
connected1438743connected
connecter1349053connecter
connects123010563connects
conned95119703conn_ed
conner84423963conn_er
conners94023113conners
conning103718753conning
connived1436423connived
conniver1337483conniver
connives1339713connives
conns75024233conn__s
console92715983console
consulate11612233consulate
consume11510133consume
contact1144020683contact
contacted14139093contacted
contactee13149313contactee
contacts123215213contacts
contain9315823contain
contes84432913co_n_tes
continuate1248323continuate
conto76027173co_n_to
contrite10318523contrite
contuse9311413contuse
convene123314323convene
convoke16207173convoke
coontie9311413coontie
copemate1439993copemate
copulate122614113copulate
coranto9311893coranto
cordage11310063cordage
cordite10315253cordite
corelate10516013corelate
corkage1438373corkage
corncake1645263corncake
cornet84436733cornet_
cornets94820573cornets
cornice11612933cornice
cornuted1137463cornuted
cornuto937023cornuto
coronae94214893corona_e
coronated123313323coronated
coronates1110816923coronates
corotate102813933corotate
corrade101111043corrade
corsage1039803corsage
costae85319683costa_e
cote66648733co___te
cottae84615703cotta_e
cottage104210573cottage
count74932053coun_t_
counted103815803coun_ted
counter94220143coun_ter
counts84618273coun_ts
county114313323coun_ty
courage10310993courage
courante1049953courante
couvade1335063couvade
cowage12310663co_wage
cowbane1437673cowbane
cowhage1636293cowhage
cowpat13312033cowpat_
cowpats1437713cowpats
cowrite123612683cowrite
cowrote12289673cowrote
coxae146115183co_xa_e
coyote11411783co_yote
cozenage2094783cozenage
craniate10312553craniate
crate76537403c__rate
create85126373c_reate
cremate113816183cremate
crenated113013913crenated
crinite9513633crinite
cuneated11310103cuneated
curate85226243c_urate
curtate9312643curtate
cuspate1138233cuspate
cyanates13238423cyanates
cyanite122710763cyanite
dentate8315153dentate
dominate11312853dominate
donated93513863do_nated
donates83217223do_nates
donna66215033donna__
donnas75511323donna_s
donne65520463donn__e
donnee74317063donn_ee
dunnage9175213dunnage
dunnite857333dunnite
echinate1359403echinate
elongate945613elongate
emanate9312473emanate
enate54428143__enate
folate93320393fo_late
foliate10513523foliate
formate123115093formate
fossate10388603fossate
foveate1338363foveate
ingate73018233_ingate
inmate82917353_inmate
innage73011573_innage
iodate7313503io_date
iodinate949343iodinate
jobname1842903jobname
khanate1437073khanate
lanate6421263_lanate
lineate7815153lineate
lobate82915243lo_bate
locate83919843lo_cate
lunate6316043_lunate
magnate10512703magnate
mandate10315573mandate
mannite9312903mannite
montage101211713montage
montane91313623montane
monte75829773mo_n_te
neonate7311333neonate
nominate10312473nominate
nonage7313683no_nage
nonfat9512183nonfat_
nongame1038173nongame
nonnative1248343nonnative
nonrated9310843nonrated
nonwage1137163nonwage
notate63217863no_tate
oblate82214743_oblate
ocreate93711743ocreate
odonate848403odonate
oleate6318883_oleate
opiate8513463_opiate
orate55133303_o_rate
outate62923403_outate
ovate84214393_o_vate
ozonate1646863ozonate
pennae84314033penna_e
penname11328553penname
pennated11299543pennated
phenate12412193phenate
phonate12411813phonate
pinnace113510313pinnace
pinnae84414643pinna_e
pinnated11338553pinnated
planate9314573planate
pointe84619313poin_te
pronate9418873pronate
quinate16511573quinate
rennase738713rennase
roseate7613453roseate
rotate63320343ro_tate
ruinate7312833ruinate
senate63725143_senate
sensate7311883sensate
sinuate7412153sinuate
solate64526073so_late
solvate102710213solvate
sonance9310313sonance
sonant6621953sonant_
sonants7511233sonants
sonata6313223so_nata
sonicate10310933sonicate
sonnet65923503sonnet_
sonneted936173sonneted
sonnets74211993sonnets
sorbate9311733sorbate
spinate93114813spinate
tannage8209583tannage
tannates81911953tannates
ternate7415483ternate
toccate1138773toccate
togate74515683to_gate
toluate7159343toluate
tonette7310373tonette
tonnages9187873tonnages
tonne54921433tonn__e
tunnage8166373tunnage
unornate848013unornate
urinate7315363urinate
venenate1147923venenate
volante1038513volante
volvate13317993volvate
wannabe1234533wannabe
zincate1838533zincate
zonae145116443zo_na_e
zonated173310533zo_nated

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 Limit1340273566.62620227.4
3Display Results3563560.1232894.3
 (SQL Overall)1786913566.90525878.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.