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

164 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
sprouting123694(None) 
spouting113511951sp_outing
grouting103410792_grouting
pouting103519942_p_outing
rerouting10311872rerouting
resprouting1445052resprouting
routing83821092__routing
scouting112612752s_couting
scrouging1335262scrouging
shouting122711792s_houting
shrouding1434752shrouding
snouting92511922s_nouting
sporting112415462sp_orting
spotting112812092sp_otting
spousing11198732sp_ousing
spoutings12245152sp_outings
sprinting12310032sprinting
sprucing1336892spr_ucing
strouding1136372strouding
uprooting1276902uprooting
uprousing1235622uprousing
aproning11311793apro_ning
arousing93811803_arousing
bruting102612993_br_uting
carousing1237893carousing
clouting113011683_clouting
drouking1436443_drouking
enrooting10128133enrooting
espousing1265003esp_ousing
flouting122610473_flouting
fronting12310443_fronting
frosting12311183_frosting
garoting10510703garo_ting
garotting1136113garotting
glouting10379693_glouting
grouping12308533_grouping
grousing103410453_grousing
knouting13226793_knouting
louting83719383__louting
misrouting1347223misrouting
outing74128153___outing
permuting1446553permuting
plotting113011013_plotting
porting103021783_p_orting
posting105622243_p_osting
potting103720893_p_otting
pouring103115863_p_ouring
poutine93316823_p_outine
prating103424453_pr_ating
printing113216083_printing
probating14311193_probating
probing123314443_pro_bing
procuring1437993_procuring
prodding13189343_prodding
producing1556143_producing
profiting1549983_profiting
progging132610383_progging
promoing13310463_promoing
promoting1439923_promoting
prompting1637203_prompting
pronating12313763_pronating
pronging123511843_pronging
proofing1439313_proofing
propping122811673_propping
prorating12314283_prorating
prosing103319383_pro_sing
proving134214073_pro_ving
prowling1449993_prowling
pruning10311733_pr_uning
ragouting1134893ragouting
rooting83522433__rooting
rotting82919683__rotting
rouging93114703__rouging
rouping103715793__rouping
rousing83920553__rousing
rousting93913273__rousting
routine72615903__routine
saluting9310553s_aluting
savouring1335193savouring
scooting113012643s_cooting
scouring112810853s_couring
scoutings12306143s_coutings
scripting1437473scripting
scrolling12187803scrolling
scrooping1446593scrooping
scrounging1443353scrounging
scrutiny1344773scr_utiny
seriating10916403seriating
serotine8313573sero_tine
serotiny1148573sero_tiny
serrating10513213serrating
shooting122812863s_hooting
shorting122514803s_horting
shotting123012383s_hotting
shroffing1943313shroffing
shuting113212053s__huting
siruping1136503sir_uping
slotting92612613s_lotting
snooting92813203s_nooting
snorting92613373s_norting
sooting82820963s__ooting
sorting83221813s__orting
souping104215533s__ouping
souring83219063s__ouring
sousing83517823s__ousing
southing122811823s__outhing
spatting113111763sp_atting
spiriting1238413spiriting
spirting112913633sp_irting
spiting103917623sp__iting
spitting113012323sp_itting
splatting1235983splatting
splinting1238193splinting
splitting1236563splitting
splodging1433303splodging
sploshing1544293sploshing
spoiling112911553sp_oiling
spoking143212223sp_o_king
sponging1238823sp_onging
spoofing14228363sp_oofing
spooking15269803sp_ooking
spooling113212563sp_ooling
spooning112811443sp_ooning
spooring113111463sp_ooring
sporing104319413sp_o_ring
sporulating1445113sporulating
spraining1248153spraining
sprattling1363053sprattling
sprawling15175123sprawling
spraying14299883spr_aying
spreading1339653spreading
sprigging1435893sprigging
spring94526013spr___ing
springing1338743springing
spritzing2135393spritzing
sprout8419403sprout___
sprouted1136393sprout_ed
sprouts949983sprout__s
sprung94610033spr_u__ng
spuing94313363sp__u_ing
spuming1248523sp__uming
spurting113111633sp_urting
stotting92811163s_totting
striating10914193striating
stroking132610943stro_king
strolling10238793strolling
stropping1436933stropping
stroudings1242743stroudings
strowing122310563stro_wing
stroying122410593stro_ying
strunting1037873strunting
strutting1037003strutting
subroutine1254513subroutine
supporting1545563supporting
surmounting1442643surmounting
swotting12268483s_wotting
swouning12246563s_wouning
syruping1434253syr_uping
throating1398403throating
touting84118453__touting
trotting92510913_trotting
trouping11249503_trouping
unrooting1098833unrooting
uprating11311113upr_ating

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.423422437.4
2DLD Change Limit1486411647.61019532.3
3Display Results1641640.0632603.2
 (SQL Overall)1786911648.09622071.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.