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

248 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
convents13261460(None) 
coinvents1445661coinvents
concents122516601concents
consents102715891consents
contents104018211contents
convects153410991convects
convenes132916911convenes
convent123919411convent_
converts133213551converts
coagents1138442coagents
coinvent1348182coinvent_
comments142913872comments
conceits122813612conceits
concent114422512concent_
concepts143110302concepts
concerts123016062concerts
confects153110872confects
congests113510382congests
connects123010562connects
consent93723112consent_
contends112810572contends
content94326152content_
contests103413382contests
contexts17378652contexts
convect143114482convect_
convene123314322conven_e
convened143412222convened
convener132913162convener
conveners142911442conveners
convenor13307612convenor
convenors14277632convenors
convented15410752convented
convert123721472convert_
convexes20278272convexes
conveys15308222conve_ys
convicts15337712convicts
corvets124715022corve_ts
covens114919262co_ven_s
coverts124813812co_verts
covets114819642co_ve_ts
invents102812052_invents
nonevents1247472nonevents
solvents1136762solvents
advents11309473_advents
bonnets94812803bonne_ts
candent10417363candent_
caveats1239803c_aveats
cements112714223c_ements
cents74730333c___ents
cholents1337623cholents
civets115212543c_ive_ts
clients938093c_lients
coagent10313973coagent_
codens94821013co_den_s
coerects1258543coerects
coexerts1734883coexerts
cogent9321003co_gent_
coinfects16344573coinfects
coinvented1643993coinvented
coinventor1562973coinventor
coinventors1652943coinventors
collects12279783collects
collets93517903colle_ts
comets105823583co_me_ts
commends15308463commends
comment1310317703comment_
compends15378253compends
conceals123111013conceals
concedes13311053concedes
conceit113218073conceit_
concenter13312213concenter
concenters14410583concenters
concept133314443concept_
concepti14328253concepti
conceptus15295863conceptus
concerns122710833concerns
concert113325223concert_
concerti122912593concerti
concerto123311613concerto
concertos132711123concertos
concocts1138633concocts
condemns1336293condemns
condense1179613condense
condenses12710133condenses
condiments1548193condiments
condones112817393condones
conducts13118703conducts
conduits111210053conduits
conenose1078593con_enose
cones76457423con_e__s
coneys115218423con_e_ys
confect143614273confect_
confers124120093confe_rs
confess12399903confe_ss
confetti1345983confetti
confetto1346253confetto
confines13315653confines
confits122811423con_fits
confluents1545413confluents
confronts1447063confronts
congeals11309853congeals
congees103517923conge_es
congener112412193congener
congeners122511123congeners
congers104223233conge_rs
conges94928173conge__s
congest104618773congest_
congrats11311433congrats
conies84338593conie__s
coniines10415363coniines
conines93827793con_ines
conins84327233con_in_s
conjuncts2043643conjuncts
conjunto1744643conjunto
conjuntos1844363conjuntos
conkers133721043conke_rs
connect113515743connect_
conners94023113conne_rs
connivent1447723connivent_
conns75024233con__n_s
conodonts1246063conodonts
conquests2045363conquests
consensus1144913consensus
consented12311943consented
consenter11312493consenter
consenters12410843consenters
consists10310593consists
consorts101512333consorts
constants11410913constants
consults10219983consults
contacts123215213contacts
contemns1237403contemns
contempts1545063contempts
contend103511893conten_d
contented12313043contented
contes84432913conte__s
contest93523233contest_
context163913433context_
continents1249563continents
contorts101112633contorts
convected1738783convected
convector1648063convector
convectors1768293convectors
convening15311193convening
conventing16311543conventing
convention15410563convention
conventions16410523conventions
conventual1546073conventual
conventuals1665143conventuals
converge1437383converge
converges1538373converges
converse13310263converse
converses14311163converses
converso1336423converso
conversos1446883conversos
converted15311563converted
converter14311013converter
converters1539633converters
convertor1448773convertor
convertors1549113convertors
convex18367743conve__x
convexity2443313convexity
convexly2343783convexly
convey144610223conve__y
conveyed17247923conveyed
conveyer16278143conveyer
conveyers17267203conveyers
conveyor16245293conveyor
conveyors17235523conveyors
convict143410983convict_
convince1547363convince
convinces1647833convinces
convokes17247703convokes
convoys15267023conv_oys
coolants1039943coolants
coparents1347973coparents
copens106119963co_pen_s
coquets18399893coque_ts
cornets94820573corne_ts
coronets103814363coronets
corrects1259573corrects
corsets94819803corse_ts
corvees124613793corve_es
corves115122523corve__s
corvet114626933corve_t_
corvette1338093corvette
corvettes1447433corvettes
corvinas13238003corvinas
cosets85824403co_se_ts
cossets95014283cosse_ts
cotangents1344163cotangents
counts84618273co__unts
courants10310803courants
coven106925043co_ven__
covenants1445893co_venants
covers114627963co_ve_rs
covert114925503co_vert_
coves105539173co_ve__s
covet105638943co_ve_t_
coveys145413503co_ve_ys
covings134511243co_vings
covins114618063co_vin_s
cozens176314923co_zen_s
cravens124010113craven_s
culverts13295313culverts
currents1038373currents
curvets12399913curve_ts
docents102810803do_cents
dovens104413903do_ven_s
events94814073__events
foments122912053fo_ments
fondants1246203fondants
incents92414533_incents
indents83114663_indents
intents72115703_intents
invent93316363_invent_
inverts103211953_inverts
invests10319683_invests
loments93413473lo_ments
moments113113123mo_ments
monuments1397633monuments
mordents1138813mordents
nonets64118703non_e_ts
nonevent11410163nonevent_
nonvenous1245753nonvenous
novenas1036893no_venas
obverts1235403_obverts
onsets64013543_onse_ts
orients7311583_orients
ovens86217453_o_ven_s
pendents1139413pendents
ponent82821593pon_ent_
portents103512823portents
prevents133012293prevents
reconvenes1546503reconvenes
reconverts1545723reconverts
reinvents1246123reinvents
rodents8611543ro_dents
solvent10310833solvent_
sonants7511233son_ants
sonnets74211993sonne_ts
sorbents10279123sorbents
tangents938713tangents
tonlets73212503tonle_ts
torments10310453torments
torrents838143torrents
vents86125933___vents
wovens12449833wo_ven_s

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622488.11018022.4
3Display Results2482480.1062339.6
 (SQL Overall)1786912488.38921300.6
 
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.