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

312 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
convent12391941(None) 
coinvent1348181coinvent
concent114422511concent
consent93723111consent
content94326151content
convect143114481convect
convene123314321convene
convents132614601convents
convert123721471convert
candent10417362candent
coagent10313982coagent
cogent9321002co_gent
coinvents1445662coinvents
comment1310317702comment
conceit113218072conceit
concents122516602concents
concept133314442concept
concert113325222concert
confect143614272confect
congest104618772congest
connect113515742connect
connivent1447722connivent
consents102715892consents
contend103511892contend
contents104018212contents
contest93523232contest
context163913432context
convects153410992convects
convened143412222convened
convener132913162convener
convenes132916912convenes
convenor13307612convenor
convented15410752convented
converts133213552converts
convex18367742conve_x
convey144610222conve_y
conveys15308222conveys
convict143410982convict
corvet114626932corve_t
coven106925042co_ven_
covens114919262co_vens
covert114925502co_vert
covet105638942co_ve_t
invent93316362_invent
nonevent11410162nonevent
ponent82821592pon_ent
solvent10310832solvent
advent102613753_advent
anent54931843_an_ent
boniest93318993boniest
bonnet85524633bonne_t
cadent94120363c_adent
carven114716663carven_
caveat11417723c_aveat
cement103321673c_ement
cent67451013c___ent
cholent12313253cholent
civet105828733c_ive_t
clement11313773clement
client8316343c_lient
cloven114211513cloven_
coagents1138453coagents
coden86128543co_den_
codens94821013co_dens
coerect11913353coerect
coexert16312363coexert
coherent13412473coherent
coinfect15276843coinfect
coinvented1643993coinvented
coinventor1562973coinventor
coldest102514763coldest
collect113314593collect
collet84030363colle_t
comet95946073co_me_t
commend144010183commend
comments142913883comments
compend144010303compend
conceal113313013conceal
concede12310103concede
conceits122813613conceits
concenter13312213concenter
concepti14328273concepti
concepts143110303concepts
concern113011963concern
concerns122710833concerns
concerti122912603concerti
concerto123311613concerto
concerts123016063concerts
concoct10312903concoct
condemn1237113condemn
condemns1336293condemns
condense1179613condense
condiment14410853condiment
condolent1249833condolent
condone102616293condone
conduct121411593conduct
conduit10713083conduit
cone67256963con_e__
coned86040053con_e_d
cones76457423con_e_s
coney105932883con_e_y
coneys115218423con_eys
confects153110873confects
confer114018683confe_r
confers124120093confers
confess12399903confess
confetti1345993confetti
confetto1346253confetto
confident1549383confident
confine12315583confine
confit113316403con_fit
confluent1446903confluent
confront13411603confront
conge85227593conge__
congeal104011683congeal
congee96024473conge_e
congeed113212313congeed
congees103517923congees
congener112412203congener
conger95024273conge_r
congers104223233congers
conges94928173conge_s
congests113510383congests
congruent1247413congruent
conies84338593conie_s
coniine9316803coniine
conin76232723con_in_
conine84528553con_ine
conines93827793conines
coning94331823con_ing
conins84327233con_ins
conjoint17410373conjoint
conjunct1945483conjunct
conjunto1744653conjunto
conked135019113conke_d
conker124721553conke_r
conkers133721043conkers
conking143618453conking
conn66229133con__n_
connects123010563connects
conned95119703conne_d
conner84423963conne_r
conners94023113conners
conning103718753conning
conns75024233con__ns
conodont11411153conodont
conquest1939553conquest
consented12311943consented
consenter11312493consenter
consist9316033consist
consort91319903consort
constant10515593constant
consult92513633consult
contact1144020683contact
conte76633203conte__
contemn1137803contemn
contemns1237403contemns
contempt1447473contempt
contends112810573contends
contented12313043contented
contes84432913conte_s
contests103413383contests
contexts17378653contexts
continent11415633continent
contort91422343contort
convected1738783convected
convector1648083convector
conveners142911443conveners
convenient1549053convenient
convening15311193convening
convenors14277633convenors
conventing16311543conventing
convention15410563convention
conventual1546093conventual
converge1437393converge
convergent1648033convergent
conversant1548213conversant
converse13310263converse
converso1336423converso
converted15311563converted
converter14311013converter
convertor1448783convertor
convexes20278273convexes
convexity2443313convexity
convexly2343783convexly
conveyed17247923conveyed
conveyer16278143conveyer
conveying1838323conveying
conveyor16245293conveyor
convicts15337713convicts
convince1547363convince
convoke16207173convoke
convoy14348543conv_oy
convoys15267023convoys
coolant9316463coolant
coolest9318643coolest
coparent12412253coparent
copen94826433co_pen_
copens106119963co_pens
coquet174318013coque_t
cornet84436733corne_t
corniest102117303corniest
coronet94227173coronet
correct11513983correct
corset85636223corse_t
corvee114320093corve_e
corvees124613793corvees
corves115122523corve_s
corvets124715023corvets
corvette1338093corvette
corvina12229503corvina
corvine122113643corvine
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
cotangent1246833cotangent
count74932053co__unt
courant9317973courant
covalent1349223covalent
cove95837073co_ve__
coved115027373co_ve_d
covenant1349693co_venant
cover105430773co_ve_r
covers114627963co_vers
coverts124813813co_verts
coves105539173co_ve_s
covets114819643co_vets
covey136121783co_ve_y
coveys145413503co_veys
covin105621123co_vin_
coving124321523co_ving
covins114618063co_vins
cowiest123614673cowiest
cowmen13810923cowmen_
coyest11316053co_yest
cozen165019703co_zen_
cozens176314923co_zens
coziest184014353coziest
craven114113933craven_
cravens124010123cravens
credent10313973credent
culvert123011773culvert
current9313693current
curvet114720243curve_t
docent92918683do_cent
donnert82815533donnert
doven94718553do_ven_
dovens104413903do_vens
event85924443__event
fervent13310063fervent
foment113718303fo_ment
fondant11311143fondant
fondest11312403fondest
fornent10312933fornent
forwent13310533forwent
honest94822423hon_est
horrent10313553horrent
incent83320723_incent
indent73021243_indent
intent63122773_intent
invents102812053_invents
invert94120083_invert
invest93014843_invest
lenient7313843lenient
loment84021473lo_ment
longest84114953longest
moment103319683mo_ment
monument1289903monument
mordent10313993mordent
nocent83217413no_cent
nonet54540843non_e_t
nonevents1247483nonevents
nonmeat9312773nonmeat
nonmen8412833nonmen_
novena936763no_vena
obvert11412993_obvert
oncet74626543_once_t
onset54730173_onse_t
orient6322533_orient
oven76624143_o_ven_
ovens86217453_o_vens
overt85630723_o_vert
pendent10314723pendent
portent93619643portent
potent84223353po_tent
prevent124016553prevent
pungent10311233pungent
reconvene1446493reconvene
reconvert1449473reconvert
reinvent1138903reinvent
ringent8315153ringent
rodent7519243ro_dent
roven85521973ro_ven_
scandent1148493scandent
solvents1136763solvents
sonant6621953son_ant
sonnet65923503sonne_t
sorbent92915243sorbent
tangent8314993tangent
toniest73218903toniest
tonlet62924703tonle_t
torment9316173torment
torrent7313413torrent
unbent83216593_unbent
unkent103116053_unkent
unpent83117373_unpent
unrent63219783_unrent
unsent63820963_unsent
unvext1658173_unvext
vent76049053___vent
woven115215173wo_ven_
wovens12449833wo_vens

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.423422437.4
2DLD Change Limit1340273127.61017612.0
3Display Results3123120.1232536.6
 (SQL Overall)1786913128.15621909.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.