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

262 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
connect11351574(None) 
confect143614271confect
connects123010561connects
convect143114481convect
bonnet85524632bonne_t
coenact11311802coenact
coerect11913352coerect
coinfect15276842coinfect
collect113314592collect
conceit113218072conceit
concent114422512concent
concept133314442concept
concert113325222concert
concoct10312902concoct
conduct121411592conduct
confects153110872confects
congest104618772congest
connected1438752connected
connecter1349052connecter
connector1347922connector
conned95119702conne_d
conner84423962conne_r
conners94023112conners
consent93723112consent
contact1144020682contact
content94326152content
contest93523232contest
context163913432context
convects153410992convects
convent123919412convent
convert123721472convert
convict143410982convict
cornet84436732corne_t
correct11513982correct
donnert82815532donnert
reconnect1347042reconnect
sonnet65923502sonne_t
bannet84925333banne_t
bennet84823363benne_t
boniest93318993boniest
bonne75124713bonne__
bonnes85621453bonne_s
bonnets94812803bonnets
bonniest10310773bonniest
bonnock1545203bonnock
candent10417363candent
canned95022063canne_d
cannel84216403canne_l
cannels93413363cannels
canner84625983canne_r
canners93822663canners
cannery123610013cannery
canniest10313363canniest
cannot83616773cann_ot
carnet84732873carne_t
cathect1439863cathect
coact96130583co__act
coagent10313983coagent
coannex1635513coanne_x
cobnut10311323cobn_ut
codec107120343co_dec_
codecs115112933co_decs
codirect13106293codirect
coeffect1843933coeffect
coenacts1246403coenacts
coerects1258543coerects
coexert16312363coexert
cogency1547013cogency
cogent9321003co_gent
cognac1157273cognac_
cognacs1256043cognacs
coined94523603coine_d
coiner84323783coine_r
coiners93620753coiners
coinfects16344573coinfects
coinvent1348183coinvent
coldest102514763coldest
collects12279783collects
collet84030363colle_t
comet95946073co_me_t
comment1310317703comment
compact153712213compact
complect1659013complect
conceal113313013conceal
concede12310103concede
conceits122813613conceits
concents122516603concents
concepti14328273concepti
concepts143110303concepts
concern113011963concern
concerti122912603concerti
concerto123311613concerto
concerts123016063concerts
conch124620073co_n_ch
concocts1138633concocts
condemn1237113condemn
conduce12139233conduce
conducts13118713conducts
conduit10713083conduit
cone67256963co_ne__
coned86040053co_ne_d
cones76457423co_ne_s
coney105932883co_ne_y
coneys115218423co_neys
confected1739073confected
confer114018683confe_r
confers124120093confers
confess12399903confess
confetti1345993confetti
confetto1346253confetto
confit113316403co_nfit
conflict1547753conflict
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congeed113212313congeed
congees103517923congees
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congests113510383congests
conic95329793co_nic_
conics103920593co_nics
conies84338593conie_s
conine84528553conine__
conines93827793conine_s
conjunct1945483conjunct
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
conn66229133conn___
connate9315753connate
connecters1448013connecters
connecting15310383connecting
connection14410533connection
connective1749253connective
connectors1448183connectors
conning103718753conning
connive1238993connive
connivent1447723connivent
connote9311613connote
conns75024233conn__s
conquest1939553conquest
consents102715893consents
consist9316033consist
consort91319903consort
consult92513633consult
contacts123215213contacts
conte76633203conte__
contemn1137803contemn
contempt1447473contempt
contend103511893contend
contents104018213contents
contes84432913conte_s
contests103413383contests
contexts17378653contexts
continent11415633continent
contort91422343contort
contract122915633contract
convected1738783convected
convector1648083convector
convene123314323convene
convents132614603convents
converts133213553converts
convex18367743conve_x
convey144610223conve_y
conveys15308223conveys
convicts15337713convicts
coolest9318643coolest
copeck1636943co_peck
coquet174318013coque_t
cornea84018933corne_a
corneal94414503corneal
corneas94717003corneas
corned95224523corne_d
cornel84020053corne_l
cornels94716663cornels
corner84625623corne_r
corners94723313corners
cornetcy1544303cornetcy
cornets94820573cornets
cornice11612933cornice
corniest102117303corniest
coronet94227173corone_t
corrects1259573corrects
corset85636223corse_t
corvet114626933corve_t
cosec96320183co_sec_
cosecs105015213co_secs
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
count74932053coun__t
covert114925503co_vert
covet105638943co_ve_t
cowiest123614673cowiest
coyest11316053co_yest
coyness1277323coyness
coziest184014353coziest
crownet123714113crowne_t
cunner83915003cunne_r
cunners93913473cunners
cygnet1237893cygne_t
disconnect1555873disconnect
donne65520463donne__
donned85015743donne_d
donnee74317063donne_e
donnees84210363donnees
donnerd9427813donnerd
dorneck1444303dorneck
dunnest83312263dunnest
fennec11326913fennec_
fennecs12305693fennecs
fondest11312403fondest
fornent10312933fornent
funnest102912003funnest
gannet74321853ganne_t
honest94822423ho_nest
hornet94926433horne_t
infect113413443_infect
inject153210233_inject
insect83916583_insect
jennet134714953jenne_t
linnet6419423linne_t
longest84114953longest
longneck1542383longneck
misconnect1654403misconnect
monoecy1445083monoecy
nonelect10410283nonelect
nonet54540843no_ne_t
nonfact1248893nonfact
noninert8415023noninert
noninsect1145493noninsect
nonmeat9312773nonmeat
nonnews1035313nonnews
object17135803_object
obtect10129633_obtect
oncet74626543_once_t
onset54730173_onse_t
pandect12310953pandect
ponent82821593po_nent
porrect1159743porrect
punnet83518843punne_t
reconnects1445133reconnects
rennet64624853renne_t
ronnel63310883ronne_l
ronnels7318613ronnels
sennet64224143senne_t
sonnets74211993sonnets
soonest7415593soonest
tannest72617853tannest
toniest73218903toniest
tonlet62924703tonle_t
tonne54921433tonne__
tonneau765913tonneau
tonner64819203tonne_r
tonners73816403tonners
tonnes65320853tonne_s
wannest103915003wannest
wonned104012063wonne_d
wonner95114443wonne_r
wonners104312813wonners

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.436409841.7
2DLD Change Limit1340272627.97016816.4
3Display Results2622620.1102381.8
 (SQL Overall)1786912628.51620983.0
 
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.