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

129 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
procuring143799(None) 
precuring1439421precuring
pouring103115862p_o_uring
proctoring1546672proctoring
producing1556142producing
armouring1244983armouring
arousing93811803aro_using
brocading1556253brocading
brokering1636283brokering
closuring1255173closuring
cloturing1245473cloturing
clouring112811273clo_uring
crocking174313443croc_king
crouching1746383crouching
curing94824783___curing
drouking1436443dro_uking
flouring123010143flo_uring
focusing1436603_focusing
fracturing1643933fracturing
frocking18309573froc_king
grouching1644943grouching
grouping12308533gro_uping
grousing103410453gro_using
grouting103410793gro_uting
hocusing1446583_hocusing
louring83916503_lo_uring
obscuring1444023obscuring
ochring13156673__ochring
pasturing1238433pasturing
pedicuring1643243pedicuring
perduring1336013perduring
perjuring1944923perjuring
picturing1436033picturing
pocking163916763p_oc_king
pooching16328983pooc_hing
porcupine1543273porcupine
poring94227273p_o__ring
portering122012303portering
posturing1238993posturing
pouching163210413p_ouching
pouting103519943p_o_uting
powering142210803p_owering
prebuying1734303prebuying
preceding15129363preceding
precising14413273precising
precluding1644173precluding
precoding15109733precoding
precutting1546423precutting
prefiring1559073prefiring
prefocusing1953133prefocusing
prehiring1548383prehiring
preluding1337053preluding
preparing14311643preparing
prescoring1547433prescoring
pressuring1346513pressuring
presuming1437663presuming
prevuing1457253prevu_ing
prewiring1547893prewiring
pricing123417343pric__ing
pricking173212603pric_king
prickling1836533prickling
probating14311193probating
probing123314443pro__bing
procaine12312273proc_aine
proceeding1644673proceeding
processing15108183processing
prochain1548483prochain_
prochein1547523prochein_
procural1246923procur_al
procurals1355283procurals
procure1138573procur__e
procured1336603procur_ed
procurer1235833procur_er
procurers1345033procurers
procures1239213procur_es
procuress1344093procuress
prodding13189343pro_dding
profaning1537293profaning
proffering1943773proffering
profiling1548233profiling
profiting1549983profiting
progging132610383pro_gging
prologing1338953prologing
promising14410973promising
promoing13310463pro_moing
promoting1439923promoting
prompting1637203prompting
promulging1642683promulging
pronating12313763pronating
pronging123511843pro_nging
proofing1439313pro_ofing
propining14310133propining
proponing1439993proponing
proposing1439673proposing
propping122811673pro_pping
prorating12314283prorating
prosecuting1645023prosecuting
prosing103319383pro__sing
prospering1547173prospering
protruding1453633protruding
proverbing1843783proverbing
providing1637963providing
proving134214073pro__ving
provoking1935133provoking
prowling1449993pro_wling
pruning10311733pr__uning
puncturing1543303puncturing
recurring1237953_recurring
recurving1536773_recurving
recusing112512883_recusing
roaring82916003_ro_aring
rocking143619633_roc_king
rockling15259383_rockling
rogering10310273_rogering
rogueing1054313_rogueing
roguing9309563_rogu_ing
rouging93114703_ro_uging
rouping103715793_ro_uping
rousing83920553_ro_using
routing83821093_ro_uting
scouring112810853sco_uring
securing11310413_securing
souring83219063_so_uring
sprouting1236943spro_uting
torturing1036253torturing
touring82915193_to_uring
trocking153612423troc_king
trouping11249503tro_uping
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.436409841.7
2DLD Change Limit1486411297.72019254.0
3Display Results1291290.0632047.6
 (SQL Overall)1786911298.21921741.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.