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

197 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
connects12301056(None) 
confects153110871confects
connect113515741connect_
convects153410991convects
bonnets94812802bonne_ts
coenacts1246402coenacts
coerects1258542coerects
coinfects16344572coinfects
collects12279782collects
conceits122813612conceits
concents122516602concents
concepts143110302concepts
concerts123016062concerts
concocts1138632concocts
conducts13118712conducts
confect143614272confect_
congests113510382congests
connected1438752connected
connecter1349052connecter
connecters1448012connecters
connector1347922connector
connectors1448182connectors
conners94023112conne_rs
consents102715892consents
contacts123215212contacts
contents104018212contents
contests103413382contests
contexts17378652contexts
convect143114482convect_
convents132614602convents
converts133213552converts
convicts15337712convicts
cornets94820572corne_ts
corrects1259572corrects
reconnects1445132reconnects
sonnets74211992sonne_ts
bannets94013843banne_ts
bennets94712163benne_ts
bonnes85621453bonne__s
bonnet85524633bonne_t_
bonnocks1644623bonnocks
cannels93413363canne_ls
canners93822663canne_rs
carnets93918403carne_ts
cathects1545793cathects
coacts105314333co__acts
coagents1138453coagents
coannexes1843643coannexes
cobnuts1135353cobn_uts
codecs115112933co_dec_s
codirects1493593codirects
coeffects1942463coeffects
coenact11311803coenact_
coerect11913353coerect_
coexerts1734883coexerts
cognacs1256043cognac_s
coiners93620753coine_rs
coinfect15276843coinfect_
coinvents1445663coinvents
collect113314593collect_
collets93517903colle_ts
comets105823583co_me_ts
comments142913883comments
compacts16368903compacts
complects1766413complects
conceals123111013conceals
concedes13311063concedes
conceit113218073conceit_
concent114422513concent_
concept133314443concept_
concepti14328273concepti
conceptus15295873conceptus
concerns122710833concerns
concert113325223concert_
concerti122912603concerti
concerto123311613concerto
concertos132711133concertos
conchs134714903co_n_chs
concoct10312903concoct_
condemns1336293condemns
conduces13129783conduces
conduct121411593conduct_
conduits111210063conduits
cones76457423co_ne__s
coneys115218423co_ne_ys
confected1739073confected
confers124120093confe_rs
confess12399903confe_ss
confetti1345993confetti
confetto1346253confetto
confits122811423co_nfits
conflicts1644793conflicts
congeals11309853congeals
congees103517923conge_es
congers104223233conge_rs
conges94928173conge__s
congest104618773congest_
congrats11311433congrats
conics103920593co_nic_s
conies84338593conie__s
conines93827793conine__s
conjuncts2043653conjuncts
conkers133721043conke_rs
connate9315753conn_ate
connecting15310383connecting
connection14410533connection
connections15410703connections
connective1749253connective
connectives1847503connectives
conned95119703conne__d
conner84423963conne__r
connives1339723connives
connote9311613conn_ote
connotes10311453connotes
conns75024233conn___s
conquests2045363conquests
consent93723113consent_
consists10310593consists
consorts101512343consorts
conspectus1653033conspectus
consults10219983consults
contact1144020683contact_
contemns1237403contemns
contempts1545063contempts
contends112810573contends
content94326153content_
contes84432913conte__s
contest93523233contest_
context163913433context_
continents1249563continents
contorts101112643contorts
contracts132212013contracts
convected1738783convected
convector1648083convector
convectors1768313convectors
convenes132916913convenes
convent123919413convent_
convert123721473convert_
convexes20278273convexes
conveys15308223conve_ys
convict143410983convict_
copecks1745873co_pecks
coquets18399893coque_ts
corneas94717003corne_as
corneitis1146493corneitis
cornels94716663corne_ls
corneous10310033corneous
corners94723313corne_rs
cornet84436733corne_t_
cornetcy1544303cornetcy
cornices12713293cornices
coronets103814363corone_ts
correct11513983correct_
corsets94819803corse_ts
corvets124715023corve_ts
cosecs105015213co_sec_s
cosets85824403co_se_ts
cossets95014283cosse_ts
counts84618273coun__ts
coverts124813813co_verts
covets114819643co_ve_ts
coyness1277323coyne_ss
crownets13407673crowne_ts
cunners93913473cunne_rs
cygnets1333813cygne_ts
disconnects1654113disconnects
donnees84210363donne_es
donnert82815533donnert_
dornecks1543643dornecks
fennecs12305693fennec_s
gannets83811443ganne_ts
hornets104113553horne_ts
infects12279713_infects
injects16257453_injects
insects93710843_insects
jennets14517633jenne_ts
linnets739833linne_ts
longnecks1642323longnecks
misconnects1753263misconnects
nonets64118703no_ne_ts
nonfacts1346073nonfacts
noninsects1253663noninsects
nonnews1035313nonne_ws
objects18123693_objects
onsets64013543_onse_ts
pandects1335843pandects
punnets9409263punne_ts
reconnect1347043reconnect_
rennets75212633renne_ts
ronnels7318613ronne_ls
sennets73712583senne_ts
sonnet65923503sonne_t_
tonlets73212503tonle_ts
tonneaus853913tonneaus
tonners73816403tonne_rs
tonnes65320853tonne__s
wonners104312813wonne_rs

Search took 8 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.406440125.6
2DLD Change Limit1461621976.61022112.3
3Display Results1971970.0762592.1
 (SQL Overall)1786911977.09225196.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.