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

219 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
trouble95771(None) 
rouble83913311_rouble
troubled1134981troubled
troubler1035291troubler
troubles1057201troubles
double94013992_double
roble75223022_ro_ble
roubles93413512_roubles
ruble74521252_r_uble
tousle64514652t_ousle
touzle15429002t_ouzle
treble8311662tr_eble
tremble1138002tremble
triable92515392triable
troublers1135002troublers
trounce936822trounce
troupe84812432trou_pe
arable81821003ar_able
arguable1135903arguable
arousable1145573arousable
arouse65019983arou_se
atremble1244113atremble
bauble103813213_bauble
bobble94115143_bobble
boucle103712783_boucle
boule74828043_bou_le
boulle84614613_boulle
brabble10349973brabble
bramble133710033bramble
cobble123615263_cobble
coble94823173_co_ble
couple104415963_couple
croupe105114433crou_pe
crouse84619363crou_se
croute84617273crou_te
crumble133410403crumble
doable93115243_doable
doubled11289953_doubled
doubler103110083_doubler
doubles103113353_doubles
doublet103914033_doublet
doubly12328963_doubly
drabble12238883drabble
dribble12368603dribble
drumble12337893drumble
dryable13237433dryable
erodable1139203erodable
erodible1145493erodible
erosible1046443erosible
errable9312183errable
foible11410383_foible
friable122612563friable
fribble14287783fribble
frounce1236153frounce
fryable15277463fryable
globule1034383globule
gobble113512983_gobble
grabble12339643grabble
gribble12297273gribble
groupable1443643groupable
groupie1045783groupie
grouse74315023grou_se
growable1435623growable
grumble12349233grumble
hobble133913433_hobble
joule124918203_jou_le
lobule82910063_lobule
nobble103814313_nobble
noble74420993_no_ble
probable1439053probable
probe94320813pro_b_e
problem1335983pro_blem
profile123211153profile
prole74527793pro__le
protyle12229453protyle
proudly1336333proudly
provable1539093provable
rabble103818243_rabble
ramble104519973_ramble
redouble1145523redouble
robe65335643_ro_b_e
robles85321693_ro_bles
role45851823_ro__le
rootle63214453_rootle
ropable111611333_ropable
rouche114714313_rouche
roue45941743_rou__e
rouge65423443_rou_ge
rouille737493_rouille
rouse56634703_rou_se
route55132073_rou_te
rowable121510303_rowable
rubble104315673_rubble
rube65532013_r_ub_e
rubel75416833_r_ubel
rubles83921703_r_ubles
rule49938423_r_u_le
rumble103718813_rumble
soluble966103soluble
storable10310733storable
strobe84513813stro_b_e
strobile1047033strobile
table75429603t__able
takable13310193takable
tamable11312853tamable
taxable1639073taxable
tenable93214493tenable
terrible1046643terrible
thimble1435873thimble
thole85620843tho__le
throstle1175703throstle
throttle1164083throttle
toddle85811033t_oddle
toggle83810873t_oggle
toile54626493t_o_ile
tole46052903t_o__le
toluole736113toluole
tootle62613813t_ootle
topple104411323t_opple
tortile7313193tortile
torula6610393toru_la
torulae758553torulae
totable92313363totable
touche114916173t_ouche
toupee8316133t_oupee
touse55430673t_ou_se
tousled84710363t_ousled
tousles74113933t_ousles
touzled17367153t_ouzled
touzles16359223t_ouzles
towable121910113towable
trachle12311853trachle
tradable1139873tradable
trample11299703trample
trauchle1344963trauchle
treacle939973treacle
treadle8310103treadle
trebled1038483tr_ebled
trebles9311443tr_ebles
trebly1138973tr_ebly
treddle936433treddle
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
trembly1435523trembly
trestle72611363trestle
tribe74420273tr_ib_e
tribune945573tribune
tribute937313tribute
trickle133613443trickle
trifle94012883tr_ifle
trindle83311363trindle
triple84215923tr_iple
triune64210183triu_ne
troche113112513tro_che
trochee122613883trochee
trochlea1345193trochlea
trode65322853tro__de
troke94821053tro__ke
troll54416533tro__ll
trolled84312263tro_lled
troller73913173tro_ller
trolley10328753tro_lley
trolls64613943tro_lls
trolly94012363tro_lly
trombone1245373trombone
trommel11315363trommel
trompe105611263tro_mpe
trone55131863tro__ne
trope75725803tro__pe
tropine93116653tropine
trotyl9236673trotyl_
trotyls10236033trotyls
troubling1234943troubling
troublous1143963troublous
trough108512023trou_gh
troughs11698683troughs
trounced1135033trounced
trouncer1035443trouncer
trounces1037063trounces
trouped103910983trouped
trouper93811433trouper
troupes94112853troupes
trouser73812473trouser
trout57332573trou__t
troutier8277153troutier
trouts66116633trou_ts
trouty95211793trou_ty
trouvere1144073trouvere
trove85221923tro__ve
trowel94211463trowel_
troweled12106113troweled
troweler11106063troweler
trowels10358363trowels
truce75118693tr_u_ce
truckle13358863truckle
trudge8318733tr_udge
true46725853tr_u__e
trueblue1042163trueblue
truffe1276233tr_uffe
truffle1384893truffle
trull54012673tr_u_ll
trulls64110283tr_ulls
truly84111553tr_u_ly
trundle8307873trundle
tubae74716643t__ubae
tube65828663t__ub_e
tubule839853t__ubule
tule45735873t__u_le
tulle54019933t__ulle
tumble103215643t_umble
tunable92511313tunable
turnable1037853turnable
typable1435883typable
undouble1145443undouble
untroubled1342503untroubled
urodele845963urodele
voluble1244503voluble
wobble133212313_wobble

Search took 8 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 Limit1340272196.92319359.7
3Display Results2192190.0762881.6
 (SQL Overall)1786912197.40524131.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.