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

196 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
convects15341099(None) 
confects153110871confects
connects123010561connects
convect143114481convect_
convents132614601convents
converts133213551converts
convicts15337711convicts
coerects1258542coerects
coinfects16344572coinfects
coinvents1445662coinvents
collects12279782collects
conceits122813612conceits
concents122516602concents
concepts143110302concepts
concerts123016062concerts
concocts1138632concocts
conducts13118712conducts
confect143614272confect_
congests113510382congests
connect113515742connect_
consents102715892consents
contacts123215212contacts
contents104018212contents
contests103413382contests
contexts17378652contexts
convected1738782convected
convector1648082convector
convectors1768312convectors
convenes132916912convenes
convent123919412convent_
convert123721472convert_
convexes20278272convexes
conveys15308222conve_ys
convict143410982convict_
corrects1259572corrects
corvets124715022corve_ts
coverts124813812co_verts
covets114819642co_ve_ts
advects13276013_advects
bonnets94812803bonne_ts
cathects1545793cathects
caveats1239803c_aveats
civets115212543c_ive_ts
coacts105314333co__acts
coagents1138453coagents
codecs115112933co_dec_s
codirects1493593codirects
coeffects1942463coeffects
coenacts1246403coenacts
coerect11913353coerect_
coexerts1734883coexerts
coinfect15276843coinfect_
coinvent1348183coinvent_
collect113314593collect_
collets93517903colle_ts
comets105823583co_me_ts
comments142913883comments
compacts16368903compacts
complects1766413complects
conceals123111013conceals
concedes13311063concedes
conceit113218073conceit_
concent114422513concent_
concept133314443concept_
concepti14328273concepti
conceptus15295873conceptus
concerns122710833concerns
concert113325223concert_
concerti122912603concerti
concerto123311613concerto
concertos132711133concertos
conchs134714903con__chs
concoct10312903concoct_
condemns1336293condemns
conduces13129783conduces
conduct121411593conduct_
conduits111210063conduits
cones76457423con_e__s
coneys115218423con_e_ys
confected1739073confected
confers124120093confe_rs
confess12399903confe_ss
confetti1345993confetti
confetto1346253confetto
confits122811423con_fits
conflicts1644793conflicts
congeals11309853congeals
congees103517923conge_es
congers104223233conge_rs
conges94928173conge__s
congest104618773congest_
congrats11311433congrats
conics103920593con_ic_s
conies84338593conie__s
conjuncts2043653conjuncts
conkers133721043conke_rs
connected1438753connected
connecter1349053connecter
connecters1448013connecters
connector1347923connector
connectors1448183connectors
conners94023113conne_rs
conquests2045363conquests
consent93723113consent_
consists10310593consists
consorts101512343consorts
conspectus1653033conspectus
consults10219983consults
contact1144020683contact_
contemns1237403contemns
contempts1545063contempts
contends112810573contends
content94326153content_
contes84432913conte__s
contest93523233contest_
context163913433context_
contorts101112643contorts
contracts132212013contracts
convecting18310433convecting
convection17411123convection
convections18411493convections
convective2049113convective
convene123314323conve_ne
convened143412223convened
convener132913163convener
conveners142911443conveners
convenor13307613convenor
convenors14277633convenors
convented15410753convented
converge1437393converge
converges1538383converges
converse13310263converse
converses14311163converses
converso1336423converso
conversos1446893conversos
converted15311563converted
converter14311013converter
converters1539633converters
convertor1448783convertor
convertors1549133convertors
convex18367743conve__x
convexity2443313convexity
convexly2343783convexly
convey144610223conve__y
conveyed17247923conveyed
conveyer16278143conveyer
conveyers17267203conveyers
conveyor16245293conveyor
conveyors17235523conveyors
convicted1746313convicted
convinces1647833convinces
convokes17247703convokes
convoys15267023conv_oys
copecks1745873co_pecks
coquets18399893coque_ts
cornets94820573corne_ts
correct11513983correct_
corsets94819803corse_ts
corvees124613793corve_es
corves115122523corve__s
corvet114626933corve_t_
corvette1338093corvette
corvettes1447433corvettes
cosecs105015213co_sec_s
cosets85824403co_se_ts
cossets95014283cosse_ts
covens114919263co_ve_ns
covers114627963co_ve_rs
covert114925503co_vert_
coves105539173co_ve__s
covet105638943co_ve_t_
coveys145413503co_ve_ys
culverts13295323culverts
curvets12399913curve_ts
dovecots1444323do_vecots
infects12279713_infects
injects16257453_injects
insects93710843_insects
invents102812053_invents
inverts103211953_inverts
invests10319683_invests
nonets64118703non_e_ts
nonevents1247483nonevents
nonfacts1346073nonfacts
nonvector1445793nonvector
nonvectors1556283nonvectors
objects18123693_objects
obverts1235403_obverts
onsets64013543_onse_ts
pandects1335843pandects
reconnects1445133reconnects
reconverts1545723reconverts
reconvicts1744383reconvicts
solvents1136763solvents
sonnets74211993sonne_ts
tonlets73212503tonle_ts

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.420425454.8
2DLD Change Limit1461621968.73616731.0
3Display Results1961960.0762578.9
 (SQL Overall)1786911969.23219355.6
 
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.