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

169 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
trounced113503(None) 
frounced1434491frounced
trounce936821trounce_
trouncer1035431trouncer
trounces1037051trounces
bounced123610552_bounced
enounced1135882enounced
flounced1433802flounced
frounce1236152frounce_
frounces1336182frounces
grounded1136572grounded
jounced17337612_jounced
pounced123510622_pounced
rounded93013502_rounded
tranced104414172tr_anced
troubled1134972troubled
trouncers1134792trouncers
trouped103910972trou_ped
truced95312052tr_u_ced
trunked12358412tr_unked
abounded1234903abounded
amounted1135533amounted
announced1243293announced
arointed939003arointed
around72712413aroun__d
aroused84914343arou_sed
aroynted1244523aroynted
bedunced1453903bedunced
bounce104014833_bounce_
bouncer113811333_bouncer
bounces113813683_bounces
bounded113613763_bounded
bronzed19308213bro_nzed
browned134710973brown_ed
brunched16317853br_unched
counted103815803_counted
craunched1764023craunched
crooned103813343croon_ed
crouched16359143crouched
crowned133912423crown_ed
crunched16328163cr_unched
denounced1344033denounced
droned84616863dro_n_ed
drouked1335543drou_ked
drownded14334433drownded
drowned12419903drown_ed
enounce937573enounce_
enounces1037603enounces
flounce1235413flounce_
flounces1335103flounces
founded124011423_founded
fronded12388863fro_nded
fronted114011273fro_nted
frowned14348833frown_ed
groaned9259973groan_ed
groined92710813groin_ed
grouched15356663grouched
ground82310273groun__d
grounder1047603grounder
grouped11419193grou_ped
groused94712833grou_sed
grouted94111503grou_ted
grunted9339283gr_unted
hounded123311033_hounded
ironed74916013iro_n_ed
jaunced17335473_jaunced
jounce153310733_jounce_
jounces16369853_jounces
lounged9468243_lounged
mounded113711983_mounded
mounted103611533_mounted
ounce77019933__ounce_
ounces83617773__ounces
ponced114314813_po_nced
pounce105214093_pounce_
pouncer113511233_pouncer
pounces114113893_pounces
pounded114112793_pounded
pranced123714043pr_anced
produced1456073produced
pronged113912393pro_nged
pronounced15243723pronounced
pruned93413113pr_un_ed
renounced1245923renounced
romanced1337253_romanced
rouged86717323_rou_ged
roughed124210943_roughed
round64318433_roun__d
roundel8308853_roundel
rounder83514593_rounder
rouped95717353_rou_ped
roused75426443_rou_sed
rousted84013323_rousted
routed75624333_rou_ted
sconced12359173sco_nced
scrounged1343133scrounged
sounded93214463_sounded
sourced1038453_sourced
stounded10276213stounded
strunted957243str_unted
swounded13314563swounded
swouned11366663swoun_ed
taunted84310963t_aunted
thonged12376833tho_nged
thorned11479403thorn_ed
thoued10429003thou__ed
throned115412173thro_n_ed
thronged13405333thro_nged
thunked15386853t_hunked
toned65435343t_o_n_ed
tonged86518903t_o_nged
touched134914963t_ouched
toughed123511693t_oughed
toured74216153t_ou_red
toused74122013t_ou_sed
tousled84710363t_ousled
touted74419743t_ou_ted
touzled17367153t_ouzled
traced94821583tr__aced
traduced1244673traduced
trained84117203train_ed
trance84718763tr_ance_
trances93919643tr_ances
trenched14289853tr_enched
trended94011763tr_ended
triced95518673tr__iced
trined74920713tr_in_ed
triune64210183triun_e_
triunes74311383triun_es
troaked12438253tro_aked
trocked144312243tro_cked
troked114114583tro__ked
trolled84312263tro_lled
trollied935893trollied
tromped124210293tro_mped
trone55131863tro_n_e_
trones65629283tro_n_es
trooped104010723tro_oped
trophied1437643trophied
trothed114010973tro_thed
trotted83711283tro_tted
trouble957703trouble_
troubler1035283troubler
troubles1057183troubles
trouncing1235153trouncing
troupe84812433trou_pe_
trouper93811413trou_per
troupes94112843trou_pes
trouser73812463trou_ser
troutier8277143troutier
trowed104714653tro__wed
troweled12106113troweled
truanted935373truanted
truce75118693tr_u_ce_
truces84916333tr_u_ces
trucked143910813tr_ucked
trudged10298043tr_udged
trued65117693tr_u__ed
trumped12439713tr_umped
truncated1244583tr_uncated
trundled10306393tr_undled
trunnel745403tr_unnel
trussed84010013tr_ussed
trusted83412783tr_usted
tuned64622313t__un_ed
tunned74014493t__unned
unrounded1135863unrounded
wounded12329763_wounded
wronged12397673wro_nged

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621697.83018666.9
3Display Results1691690.0632682.5
 (SQL Overall)1786911698.06322161.9
 
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.