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

105 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
producing155614(None) 
coproducing1953052coproducing
procuring1437992procuring
prodding13189342prod_ding
reducing12310202_reducing
reproducing1744522reproducing
traducing1374012traducing
abducing1474063_abducing
adducing1384113_adducing
arousing93811803aro_using
conducing1537693conducing
crouching1746383cro_uching
deducing1336423_deducing
drouking1436443dro_uking
educing1137683__educing
eroding9314273erod__ing
frouncing1534763frouncing
grouching1644943gro_uching
grouping12308533gro_uping
grousing103410453gro_using
grouting103410793gro_uting
inducing1237873_inducing
introducing1553813introducing
nonproducing1852523nonproducing
outproducing1852563outproducing
parodying1655423parod_ying
perduring1336013perduring
plodding13166343plod_ding
podding124113183p_od_ding
policing13311673p_olicing
poncing122913583p_o_ncing
pouching163210413p_o_uching
pouncing13318883p_ouncing
pouring103115863p_o_uring
pouting103519943p_o_uting
prancing132612163pr_ancing
prebuying1734303prebuying
precuring1439423precuring
predating13514653predating
predicting1649873predicting
predrying1645343predrying
prefacing17118743prefacing
preluding1337053preluding
presuming1437663presuming
prevuing1457253prevu_ing
pricing123417343pr__icing
priding113317543prid__ing
probating14311193probating
probing123314443pro__bing
produce1267513produc__e
produced1456073produc_ed
producer1355843produc_er
producers1454883producers
produces1347903produc_es
producible1753063producible
product1279233produc__t
production1547893production
productions1647533productions
productive1845513productive
products1376513produc_ts
profaning1537293profaning
profiling1548233profiling
profiting1549983profiting
progging132610383pro_gging
projecting22177243projecting
prologing1338953prologing
promising14410973promising
promoing13310463pro_moing
promoting1439923promoting
prompting1637203prompting
promulging1642683promulging
pronating12313763pronating
pronging123511843pro_nging
pronouncing1652923pronouncing
proofing1439313pro_ofing
propining14310133propining
proponing1439993proponing
proposing1439673proposing
propping122811673pro_pping
prorating12314283prorating
prosecting15189813prosecting
prosing103319383pro__sing
protecting151910213protecting
protruding1453633protruding
providing1637963providing
proving134214073pro__ving
provoking1935133provoking
prowling1449993pro_wling
pruning10311733pr__uning
rodding103814533_rod_ding
rodeoing1037253_rodeoing
rogueing1054313_rogueing
roguing9309563_rogu_ing
rouging93114703_ro_uging
rouping103715793_ro_uping
rousing83920553_ro_using
routing83821093_ro_uting
seducing1236503_seducing
sprouting1236943spro_uting
sprucing1336893spr__ucing
subducing1544573subducing
trouncing1235153trouncing
trouping11249503tro_uping
trucing103211843tr__ucing
uprousing1235623upro_using

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411057.92318760.7
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.37521336.2
 
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.