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

111 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
trouncers113480(None) 
trouncer1035441trouncer_
trounces1037061trounce_s
bouncers12309352_bouncers
frounces1336182frounce_s
grounders1156782grounders
pouncers12349202_pouncers
rounders92613692_rounders
troublers1135002troublers
trounce936822trounce__
trounced1135032trounce_d
troupers10359442trou_pers
trousers83910632trou_sers
announcers1242683announcers
arousers84810983arou_sers
bouncer113811333_bouncer_
bounces113813683_bounce_s
bounders114314113_bounders
bronzers19296983bro_nzers
brunchers16296253br_unchers
counters103320193_counters
crooners103911393croon_ers
croupiers1334653croupiers
crowners133710753crown_ers
crunchers16316243cr_unchers
denouncers1343403denouncers
droners84114383dro_n_ers
drowners12428273drown_ers
enounces1037603enounce_s
flounces1335103flounce_s
flounders1374613flounders
founders123911673_founders
frounce1236153frounce__
frounced1434493frounce_d
frowners14377933frown_ers
groaners9248503groan_ers
grocers103511253gro__cers
grounder1047613grounder_
groupers11358643grou_pers
grousers93810733grou_sers
grouters95910083grou_ters
grungers10298503gr_ungers
grunters9359033gr_unters
hounders123111713_hounders
ironers74813553iro_n_ers
jounces16369853_jounce_s
loungers9449003_loungers
mounters103712503_mounters
ounces83617773__ounce_s
pouncer113511233_pouncer_
pounces114113893_pounce_s
pounders113113283_pounders
prancers123210333pr_ancers
producers1454883producers
pronouncers1563283pronouncers
pruners93710723pr_un_ers
renouncers1244623renouncers
romancers1345733_romancers
roughers12329183_roughers
roundels9217753_roundels
rounder83514603_rounder_
rousers75220143_rou_sers
rousters84315683_rousters
routers74822873_rou_ters
runners74212453_r_unners
scroungers1343183scroungers
sounders93214113_sounders
taunters8259273t_aunters
thunders1236953t_hunders
toners64128003t_o_n_ers
tongers84116013t_o_ngers
tonners73816403t_o_nners
touchers133611213t_ouchers
tourers73512743t_ou_rers
touters74018353t_ou_ters
tracers94917843tr__acers
traducers1243723traducers
trainers83114643train_ers
trances93919643tr_ance_s
trenchers14288073tr_enchers
triunes74311383triun_e_s
trocars959043tro__cars
troffers14125433tro_ffers
trollers83211213tro_llers
trones65629283tro_n_e_s
troopers10289443tro_opers
trotters83310243tro_tters
troubler1035293troubler_
troubles1057203trouble_s
trouncing1235153trouncing
trouper93811433trou_per_
troupes94112853trou_pe_s
trouser73812473trou_ser_
troutier8277153troutier_
trouvere1144073trou_vere
trouveres1243773trou_veres
trouveurs1241643trouveurs
trovers103713323tro__vers
trowelers12105263trowelers
trowsers11428003tro_wsers
truces84916333tr_u_ce_s
truckers14279013tr_uckers
trudgers10256863tr_udgers
trundlers10215003tr_undlers
trunnels844513tr_unnels
trussers8348283tr_ussers
trusters83112263tr_usters
tuners64417343t__un_ers
wrongers12327773wro_ngers
youngers12336933_youngers
younkers15295763_younkers

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.406440125.6
2DLD Change Limit1486411118.17318186.8
3Display Results1111110.0631761.9
 (SQL Overall)1786911118.64220677.0
 
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.