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

136 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
violent10211081(None) 
violet92620921viole_t
cholent12313252cholent
piolet83225642piole_t
silent64125842si_lent
vilest9416842vi_lest
violence1345712violence
violently1544332violently
violets102210002violets
violin9311982violin_
violins10311452violins
violist10312142violist
violone1037152violone
virulent1146432virulent
volant9316322v_olant
aiglet74224193aigle_t
ailment9314233ailment
avirulent1243633avirulent
billet86029723bille_t
biogen9310253biogen_
biogens1038963biogens
biogeny1336023biogeny
biont7727163bio__nt
bivalent1346123bivalent
blent76230953__blent
cholents1337623cholents
cogent9321003_cogent
coolant9316463coolant
coolest9318643coolest
dialect101210263dialect
diluent8310263diluent
diplont10311693diplont
dissent84018683dissent
distent84120853distent
divalent1247783divalent
docent92918683_docent
erodent8313823erodent
evident1139993evi_dent
evilest10310473evi_lest
evillest1146353evillest
figment1379743figment
filet85540163fi_le_t
fillet95027083fille_t
fitment12710303fitment
foment113718303_foment
giblet93418893gible_t
giglet83920273gigle_t
gillnet839733gillnet
gimlet93716663gimle_t
idiolect1144353idiolect
idlest74014863_idlest
illest63615723_illest
incent83320723_incent
indent73021243_indent
indolent91311683indolent
inlet53732403_inle_t
insolent81311553insolent
intent63122773_intent
invent93316363_invent
islet54527553_isle_t
lent46360533___lent
loment84021473_loment
millet84030743mille_t
miocene1147923miocene
missent94318713missent
molest85022743_molest
moment103319683_moment
nocent83217413_nocent
nonviolent1355153nonviolent
opulent938833opulent
overlent112715293overlent
piglet93420923pigle_t
pigment12510733pigment
piolets93513193piolets
polenta9310093_polenta
ponent82821593_ponent
potent84223353_potent
reblent9614253reblent
redolent9411883redolent
relent64431853_relent
riblet84222443rible_t
rident7520193ri_dent
rillet64828853rille_t
ringent8315153ringent
rodent7519243_rodent
sileni63312143si_leni
silents73514493si_lents
sklent103614353_sklent
solvent10310833_solvent
splent84720193_splent
stolen64315063stolen_
talent6323323_talent
toilet66228093toile_t
triolet73219523triole_t
valet84337873v_ale_t
varlet9423503varle_t
varment12313243varment
veinlet101310573veinle_t
vent76049053v___ent
vialed105112593viale_d
vialing113614163vialing
vibrant12410393vibrant
vigilant1246423vigilant
vile76139803vi_le__
vilely1239443vi_lely
viler86324163vi_le_r
villein1036753villein
villeins1136043villeins
vimen104114753vi_men_
viniest103216613viniest
viol76523593viol___
viola85915543viol__a
violas93713523viol_as
violate10311553violate
violences1445493violences
violinist1247373violinist
violists1137663violists
violones1137383violones
viols86118103viol__s
vixen153010023vi_xen_
vixens16286203vi_xens
voile84719723voile__
voiles94616443voile_s
volante1038513v_olante
vole75236983v_ole__
voled95323723v_ole_d
volery1237873v_olery
voles86234043v_ole_s
voling103918023v_oling
volost9412643v_olost
volt76439533v_ol__t
wiglet105519153wigle_t
willet95124833wille_t
wisent93516343wi_sent
woolen93111373woolen_
woolens10398843woolens

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 Filter1786911340270.796224486.2
2DLD Change Limit1340271368.47015823.7
3Display Results1361360.0462956.5
 (SQL Overall)1786911369.31219189.3
 
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.