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

199 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
troubles105720(None) 
roubles93413511_roubles
trouble957711trouble_
troubled1134981troubled
troubler1035291troubler
troublers1135001troublers
doubles103113352_doubles
robles85321692_ro_bles
rouble83913312_rouble_
rubles83921702_r_ubles
tousles74113932t_ousles
touzles16359222t_ouzles
trebles9311442tr_ebles
trembles1237352trembles
troublous1143962troublous
trounces1037062trounces
troupes94112852trou_pes
arables91814973ar_ables
arouses74921293arou_ses
baubles113611863_baubles
bobbles104514913_bobbles
boucles113113003_boucles
boules84925973_bou_les
boulles93114123_boulles
brabbles11349753brabbles
brambles14308973brambles
cobbles133814823_cobbles
cobles104622883_co_bles
couples115317053_couples
crouches153711293crouches
croupes114613103crou_pes
croutes94815653crou_tes
crumbles14329683crumbles
double94013993_double_
doubled11289953_doubled
doubler103110083_doubler
doublers11288503_doublers
doublet103914033_doublet
doublets11257363_doublets
drabbles13308523drabbles
dribbles13348393dribbles
drumbles13277723drumbles
foibles1238853_foibles
fribbles15287713fribbles
frounces1336183frounces
globules1135413globules
gobbles123512583_gobbles
grabbles13339893grabbles
gribbles13307363gribbles
grouches14328213grouches
groupies1137523groupies
grouses84616543grou_ses
grumbles13288873grumbles
hobbles143313783_hobbles
joules134116823_jou_les
lobules92510813_lobules
nobbles114014523_nobbles
nobles83319723_no_bles
nombles113212343_nombles
probables1545433probables
probes104119453pro_b_es
problem1335983pro_blem
problems1434343pro_blems
profiles133211233profiles
proles84627203pro__les
protyles13249833protyles
rabbles113517973_rabbles
rambles113118313_rambles
redoubles1244263redoubles
robes75133303_ro_b_es
roble75223023_ro_ble_
roles56747983_ro__les
rootles73215633_rootles
rouches124217893_rouches
roues56039353_rou__es
rouges76022383_rou_ges
rouilles837183_rouilles
rouses65436283_rou_ses
routes66129313_rou_tes
rubbles113715113_rubbles
rubels84112993_r_ubels
rubes74928413_r_ub_es
rubies84420343_r_ubies
ruble74521253_r_uble_
rules55234253_r_u_les
rumbles114018393_rumbles
solubles1065893solubles
storables1146283storables
strobes93813263stro_b_es
strobiles1146953strobiles
tables84524883t__ables
taxables1734383taxables
thimbles1536023thimbles
tholes94919783tho__les
throstles1265893throstles
throttles1254353throttles
tobies84521023t_o_bies
toddles93211533t_oddles
toggles93710973t_oggles
toiles63923513t_o_iles
toles55147133t_o__les
toluoles835513toluoles
tombless1236773t_ombless
tootles72915603t_ootles
topples113111653t_opples
torulas759853toru_las
touches125118343t_ouches
toupees938513t_oupees
touses64229673t_ou_ses
tousle64514653t_ousle_
tousled84710363t_ousled
touzle15429003t_ouzle_
touzled17367153t_ouzled
trachles13311753trachles
tramples122610203tramples
trauchles1445493trauchles
treacles1039703treacles
treadles939703treadles
treble8311663tr_eble_
trebled1038483tr_ebled
treddles1036263treddles
tremble1138003tremble_
trembled1335253trembled
trembler1235363trembler
tremblers1334483tremblers
trestles83012553trestles
triable92515393triable_
tribes85119023tr_ib_es
tribunes1055853tribunes
tributes1047233tributes
trickles143013763trickles
trifles103814823tr_ifles
trilbies1037693trilbies
trindles93211683trindles
triples94616873tr_iples
triunes74311383triu_nes
trochees132510183trochees
troches123715343tro_ches
trochlea1345193trochlea
trochleas1444713trochleas
troilus736413tro_ilus
trokes104019263tro__kes
trolled84312263tro_lled
troller73913173tro_ller
trollers83211213tro_llers
trolley10328753tro_lley
trolleys11315693tro_lleys
trollies8310233trollies
trolls64613943tro__lls
trombones1345353trombones
trommels12254333trommels
trompes114111623tro_mpes
trones65629283tro__nes
tropes84824353tro__pes
trophies13413673trophies
tropines102214923tropines
trotyls10236033trotyl_s
troubleshot1662253troubleshot
troublesome1562133troublesome
troubling1234933troubling
troughs11698683trou_ghs
trounce936823trounce_
trounced1135033trounced
trouncer1035443trouncer
trouncers1134803trouncers
troupe84812433trou_pe_
trouped103910983trou_ped
trouper93811433trou_per
troupers10359443troupers
trouser73812473trou_ser
trousers83910633trousers
troutier8277153troutier
troutiest9127803troutiest
trouts66116633trou__ts
trouveres1243773trouveres
troves94719113tro__ves
troweled12106113troweled
troweler11106063troweler
trowelers12105263trowelers
trowels10358363trowel_s
truces84916333tr_u_ces
truckles14319383truckles
trudges9339993tr_udges
trueblues1142053trueblues
trues54925323tr_u__es
truffes1356773tr_uffes
truffles1485593truffles
trulls64110283tr_u_lls
trundles9278483trundles
trusses73813633tr_usses
tubes74826453t__ub_es
tubules9310233t__ubules
tules54532793t__u_les
tulles63218893t__ulles
tumbles113816023t_umbles
undoubles1243923undoubles
untroubled1342503untroubled
urodeles945563urodeles
wobbles143412433_wobbles

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.1561145455.1
2DLD Change Limit1461621996.51322441.6
3Display Results1991990.0802487.5
 (SQL Overall)1786911996.74926476.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.