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

150 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
trouncer103544(None) 
trounce936821trounce_
trounced1135031trounced
trouncers1134801trouncers
trounces1037061trounces
bouncer113811332_bouncer
frounce1236152frounce_
frounced1434492frounced
frounces1336182frounces
grounder1047612grounder
pouncer113511232_pouncer
rounder83514602_rounder
troubler1035292troubler
trouper93811432trou_per
trouser73812472trou_ser
troutier8277152troutier
announcer1143293announcer
arouser74514423arou_ser
bounce104014833_bounce_
bounced123610553_bounced
bouncers12309353_bouncers
bounces113813683_bounces
bouncier1236033_bouncier
bounder104215533_bounder
bronzer18348493bro_nzer
browner124911643brown_er
brownier13226913brownier
bruncher15347783br_uncher
counter94220153_counter
crooner93714043croon_er
croupier1246883croupier
crowner124012603crown_er
cruncher15338073cr_uncher
denouncer1244133denouncer
droner74717673dro_n_er
drowner11369803drown_er
drunker12326633dr_unker
enounce937573enounce_
enounced1135883enounced
enounces1037603enounces
flounce1235413flounce_
flounced1433803flounced
flounces1335103flounces
flouncier1442483flouncier
flounder1235103flounder
founder114312573_founder
fronter103611583fro_nter
frouzier2043703frouzier
frowner13429683frown_er
groaner82510133groan_er
grocer94212143gro__cer
grounded1136573grounded
grounders1156783grounders
grouper104210093grou_per
grouser84513693grou_ser
grouter84412523grou_ter
groutier9297173groutier
grunger9389783gr_unger
grunter83110783gr_unter
hounder113412233_hounder
ironer64216453iro_n_er
jounce153310733_jounce_
jounced17337613_jounced
jounces16369853_jounces
jouncier1734423_jouncier
kroner104612573kro_n_er
lounger84610213_lounger
mounter93713173_mounter
ounce77019933__ounce_
ounces83617773__ounces
pounce105214093_pounce_
pounced123510623_pounced
pouncers12349203_pouncers
pounces114113893_pounces
pounder103314003_pounder
prancer113613383pr_ancer
producer1355843producer
pronouncer1453923pronouncer
prouder10310383prou_der
pruner83413453pr_un_er
renouncer1145843renouncer
romancer1247293_romancer
rougher113511033_rougher
rounded93013503_rounded
roundel8308853_roundel
rounders92613693_rounders
roupier9319493_roupier
rouser65224083_rou_ser
rouster73517083_rouster
router65025843_rou_ter
runner63814463_r_unner
scrounger1243443scrounger
sounder83315383_sounder
stronger9349693stro_nger
taunter73111453t_aunter
thornier1135323thornier
thunder1136963t_hunder
toner55336243t_o_n_er
tonger74719683t_o_nger
tonier65520713t_o_nier
tonner64819203t_o_nner
toucher124814353t_oucher
tougher114210983t_ougher
tourer64115073t_ou_rer
touter63821033t_ou_ter
tracer84820233tr__acer
traducer1144583traducer
trainer73316793train_er
trance84718763tr_ance_
tranced104414173tr_anced
trances93919643tr_ances
trencher13279313tr_encher
triune64210183triun_e_
triunes74311383triun_es
trocar848773tro__car
troffer13125863tro_ffer
troller73913173tro_ller
trone55131863tro_n_e_
trones65629283tro_n_es
trooper94210363tro_oper
trotter73312253tro_tter
trouble957713trouble_
troubled1134983troubled
troublers1135003troublers
troubles1057203troubles
trouncing1235153trouncing
troupe84812433trou_pe_
trouped103910983trou_ped
troupers10359443trou_pers
troupes94112853trou_pes
trousers83910633trou_sers
trouvere1144073trou_vere
trouveur1141673trouveur
trover95014663tro__ver
troweler11106063troweler
truce75118693tr_u_ce_
truced95312053tr_u_ced
truces84916333tr_u_ces
trucker134010733tr_ucker
trudger9338733tr_udger
truer54916643tr_u__er
trundler9256153tr_undler
trunked12358413tr_unked
trunnel745403tr_unnel
trusser74010263tr_usser
truster73114313tr_uster
tuner56022683t__un_er
wronger11288823wro_nger
younger11387163_younger
younker14316453_younker

Search took 7 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.406440125.6
2DLD Change Limit1461621506.51622431.2
3Display Results1501500.0602500.0
 (SQL Overall)1786911506.98225593.1
 
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.