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

133 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
trouncing123515(None) 
frouncing1534761frouncing
bouncing13318772_bouncing
enouncing1245582enouncing
flouncing1533902flouncing
grounding1236082grounding
jouncing18336852_jouncing
pouncing13318882_pouncing
rounding102812282_rounding
trancing112812022tr_ancing
troubling1234942troubling
trouping11249502trou_ping
trucing103211842tr_u_cing
abounding1335193abounding
amounting1236643amounting
announcing1342993announcing
arointing1049363arointing
arousing93811803arou_sing
aroynting1344633aroynting
beduncing1543913beduncing
bounding123012133_bounding
bronzing2037693bro_nzing
browning14299643brown_ing
brunching17316483br_unching
counting113115273_counting
craunching1843313craunching
crooning113112113croon_ing
crouching1746383crouching
crowning143510033crown_ing
crunching17297003cr_unching
denouncing1443883denouncing
droning93013723dro_n_ing
drouking1436443drou_king
drownding1564123drownding
drowning13298363drown_ing
flouncings1641673flouncings
founding133010793_founding
fronting12310443fro_nting
frowning15307833frown_ing
groaning102410283groan_ing
groining102310633groin_ing
grouching1644943grouching
groundings1343743groundings
groundling1343393groundling
grouping12308533grou_ping
grousing103410453grou_sing
grouting103410793grou_ting
grunting10269583gr_unting
hounding132610053_hounding
ironing82414013iro_n_ing
jauncing18314783_jauncing
lounging1036753_lounging
mounding123311263_mounding
mounting112711813_mounting
poncing122913583_po_ncing
pounding123311473_pounding
prancing132612163pr_ancing
producing1556143producing
pronging123511843pro_nging
pronouncing1652923pronouncing
pruning10311733pr_un_ing
renouncing1345103renouncing
romancing1446043_romancing
roughing13278343_roughing
rouging93114703_rou_ging
rouping103715793_rou_ping
rousing83920553_rou_sing
rousting93913273_rousting
routing83821093_rou_ting
running83514593_r_unning
sconcing1338263sco_ncing
scrounging1443353scrounging
sounding102712873_sounding
sourcing1158353_sourcing
stounding1136233stounding
strouding1136373strou_ding
strunting1037873str_unting
swounding1434133swounding
swouning12246563swoun_ing
taunting93510933t_aunting
thorning1237513thorn_ing
thouing11258603thou__ing
thronging1435073thro_nging
throning1238863thro_n_ing
thunking16196953t_hunking
tonging93314513t_o_nging
toning74025793t_o_n_ing
touching143211343t_ouching
toughing13278553t_oughing
touring82915193t_ou_ring
tousing82916993t_ou_sing
tousling938793t_ousling
touting84118453t_ou_ting
touzling1835503t_ouzling
tracing103720153tr__acing
traducing1374013traducing
training93015863train_ing
trenching15227653tr_enching
trending103012833tr_ending
tricing103417353tr__icing
trining82919213tr_in_ing
troaking133310973tro_aking
trocking153612423tro_cking
troking123514103tro__king
trolling93212493tro_lling
trollying1354053trollying
tromping13319603tro_mping
trooping112710283tro_oping
trophying1844713trophying
trothing122410843tro_thing
trotting92510913tro_tting
trounce936823trounc__e
trounced1135033trounc_ed
trouncer1035443trounc_er
trouncers1134803trouncers
trounces1037063trounc_es
troweling1376363troweling
trowing113413703tro__wing
truanting1035603truanting
trucking153310163tr_ucking
trudging11266443tr_udging
trueing83410183tr_u_eing
truing73913933tr_u__ing
trumping13308733tr_umping
truncating1344233tr_uncating
trundling1135003tr_undling
trussing9268653tr_ussing
trusting93411653tr_usting
tuning74016843t__un_ing
tunning83514453t__unning
unrounding1244873unrounding
wounding13249403_wounding
wronging13327393wro_nging

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411336.85621680.4
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.32524394.7
 
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.