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

139 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
proceeds133598(None) 
proceed12310551proceed_
precedes13310712precedes
proceeded1544102proceeded
proceeder1444172proceeder
proceeders1543602proceeders
process11310402proc_ess
propends13249172propends
proteids11259942proteids
protends113010352protends
breeds94914883br__eeds
brocades1358713brocades
brockets16328123brockets
creeds94714773cr__eeds
croceins1238103croceins
crochets15359833crochets
crocked164014433crocked_
crockets16339543crockets
exceeds1733843_exceeds
frocked17439333frocked_
frosteds12305653frosteds
greeds84314283gr__eeds
grocers103511253groc_ers
ironweeds1342783ironweeds
parolees104313983parolee_s
pigweeds1553143pigweeds
pinweeds1454143pinweeds
pioneers1035863pioneers
pocked154818983p_ocked_
pockets154612253p_ockets
pooched152810083pooched_
pooches143214163pooche_s
porches143815673porche_s
portends11358963portends
poteens92910883p_oteens
prebends13347883prebends
precede1239653prec_ede
preceded1438293preceded
precents123015043precents
precepts14268893precepts
precess11310863prec_ess
precodes13711573precodes
preed85128123pr__eed_
preens85020113pr__eens
prees75937173pr__ee_s
premeds12389593pr_emeds
preteens1038123preteens
pretends11299113pretends
priced115018883pric_ed_
priceless1336883priceless
pricers113915063pric_ers
prices104524543pric_e_s
pricked164613833pricked_
prickers163710673prickers
prickets16329083prickets
probands13228393probands
probed114114823pro_bed_
probers113514583pro_bers
probes104119453pro_be_s
problems1434343problems
procarps1445973procarps
proceeding1644673proceeding
proceedings1752133proceedings
processed1446803processed_
processers1446003processers
processes13310233processes
prochein1547523prochein
proctors12311513proctors
procured1336603procured_
procurers1345033procurers
procures1239213procures
procuress1344093procuress
prodded1257733prodded_
prodders1237463prodders
prods85523553pro___ds
proems104711163pro__ems
profess1237713pro_fess
proffers16126593proffers
progged12409803progged_
proggers12258163proggers
progress1137023progress
projects1936413projects
projets1639163pro_jets
prolegs10379993pro_legs
proles84627203pro_le_s
promoed12310083promoed_
proneness11310443proneness
pronged113912393pronged_
proofed13138723proofed_
proofers13118363proofers
propels113412843pro_pels
propend123311273propend_
propenes122816513propenes
propers113619033pro_pers
prophets1539503prophets
propjets1935493propjets
propped113311953propped_
prosects1239473prosects
prosed94921093pro_sed_
prosers94219643pro_sers
proses84733473pro_se_s
prospers123012263prospers
prosses94019513prosse_s
proteans102811543proteans
proteas92015123pro_teas
protects1239743protects
protegees1275393protegees
proteges1149923proteges
proteid103513673proteid_
proteide11239723proteide
proteides12238783proteides
proteins102114283proteins
protend104012793protend_
protests10310493protests
proteus92511593pro_teus
proved125016033pro_ved_
proverbs15315583proverbs
provers123817793pro_vers
proves114322253pro_ve_s
provides1439883provides
prowess1237903pro_wess
prowled13309913prowled_
prowlers13328933prowlers
proxies163014933proxie_s
psocids1234863psoc_ids
recedes102816063_recedes
reeds65430903_r__eeds
refeeds11368973_refeeds
reseeds84012333_reseeds
rochets124213473_rochets
rocked135022323_rocked_
rockers133916553_rockers
rockets134615363_rockets
rockweeds1942833_rockweeds
sprockets1743253sprockets
succeeds1343693succeeds
trochees132510183trochees
troches123715343troche_s
trocked144312243trocked_

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621397.37619815.9
3Display Results1391390.0433232.6
 (SQL Overall)1786911397.84222786.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.