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

151 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
scourging133457(None) 
scouring112810851scour_ing
coursing113112022_coursing
courting112514572_courting
scoring103117212sco_r_ing
scorning1169132sco_rning
scourings12235292scour_ings
scouting112612752scou_ting
scrouging1335262scrou_ging
scrounging1443352scrounging
sourcing1158352s_ourcing
souring83219062s_our_ing
splurging1333622splurging
surging93115432s__urging
bescouring1584643bescour_ing
charging152910773_charging
chugging1634913_chugging
churning14237173_churning
churring14298653_churring
clouring112811273clour_ing
coercing1349003_coercing
cogging123513713_co_gging
cording113620823_co_rding
coring94433963_co_r_ing
corking143018823_co_rking
corning103720123_co_rning
couching163213263_couching
coughing15309213_coughing
counting113115263_counting
couping124317023_cou_ping
coupling13310783_coupling
coursings12235873_coursings
curbing123814023_c_urbing
curding113515133_c_urding
curing94824783_c_ur_ing
curling104320183_c_urling
curring103616843_c_urring
cursing104217033_c_ursing
curving133912103_c_urving
discouraging1753123discouraging
discoursing1544853discoursing
encouraging1552873encouraging
escorting1237713esco_rting
flouring123010143flour_ing
forging124114723_fo_rging
gorging102611363_go_rging
gouging103410703_gou_ging
gurging102910113__gurging
lounging1036753_lounging
louring83916503_lour_ing
mourning1156793_mourning
occurring1443693occurring
pouring103115863_pour_ing
purging113314183__purging
resurging1138613resurging
rouging93114703_rou_ging
savouring1335193savour_ing
scarfing14309713sc_arfing
scaring103421973sc_ar_ing
scarping133312463sc_arping
scarring112511513sc_arring
scarting113415263sc_arting
schussing1542953schussing
sciurine1045233sciur_ine
scoffing17275943sco_ffing
scolding12278913sco_lding
sconcing1338263sco_ncing
scooching1735073scooching
scooping133610633sco_oping
scooting113012633sco_oting
scoping123513823sco__ping
scorching1735633scorching
scotching1735653scotching
scourge1035653scourg__e
scourged1234573scourg_ed
scourger1134723scourg_er
scourgers1234383scourgers
scourges1136533scourg_es
scoutings12306143scou_tings
scowing133812093sco__wing
scowling1458283sco_wling
scragging1435273scragging
scrubbing1633933scrubbing
scrumming1654023scrumming
scrupling1435193scrupling
scrying1338663sc__rying
scubaing1335733sc_ubaing
scudding1335673sc_udding
scuffing17287113sc_uffing
sculking15307913sc_ulking
sculling112910993sc_ulling
sculping13298943sc_ulping
scumming15256793sc_umming
scurrying15183833scurrying
securing11310413secur_ing
serging93416673s__erging
shogging14308013sho_gging
shoring112820063sho_r_ing
shorting122514793sho_rting
shouting122711783shou_ting
showring1548313showr_ing
shrugging1533703shrugging
slogging113410493slo_gging
slouching15195723slouching
sloughing14244753sloughing
sludging11268363s_ludging
slugging11339423s_lugging
slurping11278123s_lurping
slurring9288833s_lurring
smudging13255723s_mudging
snogging11318043sno_gging
snoring83917203sno_r_ing
snorting92613373sno_rting
snouting92511923snou_ting
snugging11286933s_nugging
soaring83521893s_oar_ing
sojourning1841713sojourning
sorbing102815263s_o_rbing
soring74731883s_o_r_ing
sorning83116813s_o_rning
sorting83221813s_o_rting
soughing13259733s_oughing
sounding102712873s_ounding
souping104215533s_ou_ping
sourdine936893s_ourdine
sousing83517823s_ou_sing
southing122811823s_outhing
sparging122611133s_parging
sponging1238823spo_nging
spooring113111463spoor_ing
sporing104319413spo_r_ing
sporting112415463spo_rting
spousing11198733spou_sing
spouting113511953spou_ting
spurning11258663s_purning
spurring11339763s_purring
spurting113111633s_purting
stodging11277463sto_dging
stooging102810043sto_oging
storing83921123sto_r_ing
storming11209423sto_rming
storying12249673sto_rying
stounding1136233stounding
succouring1543833succour_ing
surfing112914483s__urfing
suturing9310373sutur_ing
swounding1434133swounding
swouning12246563swou_ning
touring82915193_tour_ing
upsurging1343353upsurging
urging83413123___urging

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.1731032896.0
2DLD Change Limit1486411518.29617917.2
3Display Results1511510.0632396.8
 (SQL Overall)1786911518.53220943.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.