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

164 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
convented1541075(None) 
coinvented1643991coinvented
consented12311941consented
contented12313041contented
convected1738781convected
convened143412221conven_ed
converted15311561converted
commented16129612commented
conceited14310422conceited
concenter13312212concenter
concerted14312112concerted
condensed1387112condensed
confected1739072confected
congested1338672congested
connected1438752connected
consenter11312492consenter
contended1339272contended
contested12310692contested
convene123314322conven_e_
convener132913162conven_er
convenes132916912conven_es
convent123919412convent__
convents132614602convent_s
converged1636962converged
conversed1538682conversed
converter14311012converter
conveyed17247922conve_yed
convicted1746312convicted
convinced1745362convinced
coveted133011522co_ve_ted
invented122510662_invented
nonvested1346002nonvested
bonneted1136223bonne_ted
caveated1439133c_aveated
cemented1338373c_emented
cocreated142710093cocreated
coerected1447643coerected
coexerted1944763coexerted
coinfected1843823coinfected
coinvent1348183coinvent__
coinventor1562973coinventor
coinvents1445663coinvent_s
collected1447963collected
colleted113011653colle_ted
commenced18157133commenced
commended17137013commended
commenter151410693commenter
competed154113593compe_ted
concealed1458133concealed
conceded1438283conce_ded
conceived1746713conceived
concent114422513concent__
concentered1645003concentered
concenters14410583concenters
concents122516603concent_s
concerned1438643concerned
concocted1346763concocted
concreted1439413concreted
condemned1545103condemned
condense1179613condense_
condenser1287413condenser
condenses12710133condenses
condoned122612023condon_ed
conducted1547313conducted
conferred1537753conferred
confessed1546053confessed
confined14310403confin_ed
conflated1539333conflated
confronted1644193confronted
confuted1437683con_futed
congealed1346593congealed
congeed113212313conge__ed
congener112412203congen_er
connecter1349053connecter
conned95119703con__n_ed
connoted1138863con_noted
consent93723113consent__
consenters12410843consenters
consents102715893consent_s
conserved1538853conserved
consisted1238503consisted
consorted1239773consorted
consulted1277923consulted
contacted14139093contacted
contemned1446793contemned
contend103511893conten__d
contender1239563contender
content94326153content__
contentedly1754903contentedly
contents104018213content_s
contester11311183contester
continued1248483continued
contorted1239473contorted
convect143114483convect__
convector1648083convector
convects153410993convect_s
conveners142911443conveners
convenient1549053convenient
convening15311193convening
convenor13307613conven_or
convenors14277633convenors
conventing16311543conventing
convention15410563convention
conventual1546083conventual
converge1437383converge_
converges1538373converges
converse13310263converse_
converser1438093converser
converses14311163converses
convert123721473convert__
converters1539633converters
convertor1448783convertor
converts133213553convert_s
convexes20278273conve_xes
conveyer16278143conve_yer
convince1547363convince_
convincer1645833convincer
convinces1647833convinces
convoked18236163conv_oked
convoluted1643703convoluted
convolved1844083convolved
convoyed17225553conv_oyed
convulsed1544383convulsed
coparented1544853coparented
coquetted2154823coquetted
coroneted12278323coroneted
corrected1438113corrected
corseted11311473corse_ted
corvette1338093corvette_
corvettes1447433corvettes
cosseted1178343cosse_ted
counted103815803co__unted
covenanted1663803co_venanted
covered133315293co_ve_red
coveter122912063co_ve_ter
cozened19349183co_zen_ed
cravened1476713craven_ed
cuneated11310103cun_eated
curveted1435293curve_ted
curvetted1543703curvetted
dovened12389063do_ven_ed
fomented1437803fo_mented
foveated1536293fo_veated
incented112412543_incented
indented101811733_indented
invected14258883_invected
inventer112410843_inventer
inverted122312163_inverted
invested12229693_invested
obverted1435103_obverted
oriented937483_oriented
prevented1539003prevented
reconvened1645393reconven_ed
reconverted1745653reconverted
reinvented1445133reinvented
sonneted936183sonne_ted
sonnetted1044543sonnetted
tormented1245963tormented
unconverted1744773unconverted
undented102313953_undented
unrented92413923_unrented
untented92613413_untented
unvested122210223_unvested
vented104617923___vented

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411647.31320325.6
3Display Results1641640.0762157.9
 (SQL Overall)1786911647.54523683.4
 
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.