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

172 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
trounce93682(None) 
frounce1236151frounce
trounced1135031trounced
trouncer1035441trouncer
trounces1037061trounces
bounce104014832_bounce
enounce937572enounce
flounce1235412flounce
frounced1434492frounced
frounces1336182frounces
jounce153310732_jounce
ounce77019932__ounce
pounce105214092_pounce
trance84718762tr_ance
triune64210182triun_e
trone55131862tro_n_e
trouble957712trouble
trouncers1134802trouncers
troupe84812432trou_pe
truce75118692tr_u_ce
announce1044323announce
around72712413aroun_d
arouse65019983arou_se
bedunce1235683bedunce
bounced123610553_bounced
bouncer113811333_bouncer
bounces113813683_bounces
bouncy13409073_bouncy
bronc91714343bro_nc_
bronco10179493bro_nco
broncs101611153bro_ncs
bronze173610923bro_nze
brownie12178433brownie
brunch13329353br_unch
craunch1464443craunch
crone75231333cro_n_e
crouch133910203crou_ch
croupe105114433crou_pe
crouse84619363crou_se
croute84617273crou_te
crunch13349503cr_unch
denounce1145103denounce
douce85518423_dou_ce
drone65324983dro_n_e
dunce86319263__dunce
enounced1135883enounced
enounces1037603enounces
flounced1433803flounced
flounces1335103flounces
flouncy1543673flouncy
grouch12318473grou_ch
ground82310273groun_d
grounded1136573grounded
grounder1047613grounder
grounds9228313grounds
groupie1045783groupie
grouse74315023grou_se
groyne1037213groyn_e
grunge8359583gr_unge
irone55126363iro_n_e
jaunce15367433_jaunce
jounced17337613_jounced
jounces16369853_jounces
jouncy18336203_jouncy
krone94018733kro_n_e
launce8469183_launce
lounge75211213_lounge
nonce75719823_no_nce
once65423083__o_nce
ounces83617773__ounces
ponce95222513_po_nce
pounced123510623_pounced
pouncer113511233_pouncer
pounces114113893_pounces
prance104318573pr_ance
prince104114763pr_ince
produce1267513produce
prone75332623pro_n_e
pronounce1354663pronounce
province1546923province
prune75119633pr_un_e
rance75028513_r_ance
raunch11358433_raunch
renounce1047403renounce
romance11311083_romance
rouble83913313_rouble
rouche114714313_rouche
roue45941743_rou__e
rouge65423443_rou_ge
round64318433_roun_d
rounded93013503_rounded
roundel8308853_roundel
rounder83514603_rounder
rounds73615623_rounds
rouse56634703_rou_se
route55132073_rou_te
rune45236303_r_un_e
sconce104711723sco_nce
scrounge1143913scrounge
source8410673_source
thence112010843t_hence
throne98517603thro_n_e
tone46953743t_o_n_e
tonne54921433t_o_nne
toonie63617993t_oonie
torulae758553torulae
touch106519393t_ou_ch
touche114916173t_ouche
toupee8316133t_oupee
touse55430673t_ou_se
tousle64514653t_ousle
touzle15429003t_ouzle
townee92815213t_ownee
townie93312303t_ownie
trace75829613tr__ace
traduce1036353traduce
trainee72817793trainee
tranced104414173tr_anced
trances93919643tr_ances
tranche123312223tr_anche
trench114211613tr_ench
tribune945573tribun_e
trice75127493tr__ice
triene64316383trien_e
trine54734603tr_in_e
triunes74311383triunes
troche113112513tro_che
trochee122613883trochee
trock114817603tro__ck
trode65322853tro__de
troke94821053tro__ke
trompe105611263tro_mpe
trona54118953tro_n_a
tronas63816903tro_nas
trones65629283tro_nes
trope75725803tro__pe
tropic103014193tropic_
tropics113610653tropics
tropine93116653tropine
troubled1134983troubled
troubler1035293troubler
troubles1057203troubles
trough108512023trou_gh
troughs11698683troughs
trouncing1235153trouncing
trouped103910983trouped
trouper93811433trouper
troupes94112853troupes
trouser73812473trouser
trout57332573trou__t
troutier8277153troutier
trouts66116633trou_ts
trouty95211793trou_ty
trouvere1144073trouvere
trove85221923tro__ve
truancy1244993truancy
truced95312053tr_u_ced
truces84916333tr_u_ces
truck116115463tr_u_ck
trudge8318733tr_udge
true46725853tr_u__e
truffe1276233tr_uffe
truncate1046283tr_uncate
trundle8307873tr_undle
trunk94713043tr_un_k
trunked12358413tr_unked
trunks10429753tr_unks
trunnel745403tr_unnel
tune45635863t__un_e
twoonie1034423twoonie
twopence1542953twopence
usaunce9103383usaunce

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271725.86022871.5
3Display Results1721720.0632730.2
 (SQL Overall)1786911726.32928233.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.