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

119 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
parvenus133565(None) 
parvenu1247021parvenu_
parvenue1344921parvenue
parvenues1444641parvenues
parents93418122par_ents
pareus85420742par_e_us
advents11309473_advents
arenas65021993_ar_enas
arenes64928393_ar_enes
arenous7314183_ar_enous
argents84014853_argents
arpens84814823_arpen_s
arpents93613083_arpents
arsenous847533_arsenous
avens86419333_a_ven_s
avenue957953_a_venue
avenues1057183_a_venues
barrens94414323barren_s
bartends1136793bartends
careens94514703careen_s
carvels124914593carve_ls
carven114716663carven__
carvers124817543carve_rs
carves115128453carve__s
carvings143810213carvings
cravens124010123craven_s
darkens12409873darken_s
davens104612913da_ven_s
gardens93312093garden_s
garments1139963garments
garveys14124463garve_ys
hardens113815023harden_s
harkens144112863harken_s
harvests14246173harvests
havens124514043ha_ven_s
jarveys20123413jarve_ys
larcenous1145013larcenous
margents11410133margents
martens93714953marten_s
marvelous1444373marvelous
marvels123810093marve_ls
mavens114312973ma_ven_s
pandanus1136433pandanus
pangenes112612823pangenes
pangens103112063pangen_s
paraments13511553paraments
parangs104314373par_angs
paravanes1448303paravanes
parcels113712663parce_ls
parcener1238473parcener
parceners1337453parceners
pardners11269193pardners
pardons103817623pardon_s
parent83230423par_en_t
pareos87023773par_e_os
parers85530743par_e_rs
pares77164483par_e__s
pareses94718883par_eses
paresis93315093par_esis
pareu74928743par_e_u_
parges94529543parge__s
pargets105215193parge_ts
pargings123410163pargings
parians93519733parian_s
paries84742513parie__s
parietes10714543parietes
parings104219213par_ings
parkers133816873parke_rs
parkings153610683parkings
parles86334403parle__s
parleys125212373parle_ys
parlous9414293par_lous
parous84024163par__ous
parrels94713493parre_ls
parsecs11429923parse_cs
parsers94118153parse_rs
parses85534703parse__s
parsons93516873parson_s
partans94418283partan_s
partings113513733partings
partners102711133partners
partons94620513parton_s
parve109824853parve___
parvis116114803parv__is
parvises133911913parvises
parvos116614753parv__os
patens84820863pa_ten_s
patents94815203pa_tents
patients1088763patients
pattens95414923patten_s
pavanes123612653pa_vanes
pavans115715593pa_van_s
pavers115021823pa_ve_rs
paves104833923pa_ve__s
pavings134011633pa_vings
pavins114919663pa_vin_s
payments1536943payments
percents122713373percents
perpends13227753perpends
perpents122312043perpents
perverts1337533perverts
pervious1337543pervious
portends11358963portends
portents103512823portents
preens85020113p_reen_s
prevents133012293prevents
prunus8399363p_r_unus
pulvinus1343263pulvinus
purveys15615903purve_ys
pyrenes123511223pyr_enes
ravenous1146793ra_venous
ravens93916883ra_ven_s
sarments10311963sarments
sarsens7311393sarsen_s
varments1339063varments
varves124414783varve__s
venus84918903___venus
wardens113711903warden_s
warrens103810893warren_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.423422437.4
2DLD Change Limit1461621197.61019206.6
3Display Results1191190.0462587.0
 (SQL Overall)1786911198.07922118.0
 
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.