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

173 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
stubbled138507(None) 
stubbed12378081stubb_ed
stubble1136841stubble_
stubbles1236841stubbles
stumbled1335621stumbled
bubbled113612122_bubbled
rubbled124611622_rubbled
scabbled15156302scabbled
scumbled1535052scumbled
slubbed12339282slubb_ed
snubbed12347442snubb_ed
squabbled2342562squabbled
stabbed123510372stabb_ed
stabled103514952st_abled
stobbed12287492stobb_ed
stubbier1235352stubbier
stubblier1343202stubblier
stubbly1444472stubbl_y
stumble1147552stumble_
stumbler1235812stumbler
stumbles1237492stumbles
subbed114116672s_ubb_ed
tubbed114712222_tubb_ed
tumbled123412242_tumbled
abubble1044523abubble_
babbled113612863_babbled
blubbed11338393blubb_ed
bobbled113811833_bobbled
brabbled12337633brabbled
bubble94016593_bubble_
bubbler103611783_bubbler
bubbles104315963_bubbles
bumbled144113043_bumbled
burbled124312673_burbled
clubbed14307453clubb_ed
cobbled143411633_cobbled
cribbled15305803cribbled
crumbled15357443crumbled
dabbled133712073_dabbled
dibbled133510843_dibbled
doubled11289953dou_bled
drabbled14367053drabbled
dribbled14376593dribbled
drubbed13406983drubb_ed
drumbled14266033drumbled
dubbed124113213_dubb_ed
flubbed15306633flubb_ed
fribbled16305743fribbled
fubbed144711243_fubb_ed
fumbled153710493_fumbled
gabbled134112453_gabbled
gobbled134010253_gobbled
grabbled14327373grabbled
grubbed13406433grubb_ed
grumbled14256753grumbled
hobbled153310783_hobbled
humbled153711813_humbled
jumbled19379963_jumbled
kibbled16367983_kibbled
mumbled143010763_mumbled
nibbled12389073_nibbled
nobbled123511283_nobbled
nubble103813713_nubble_
nubbles113412433_nubbles
pebbled1445403_pebbled
quibbled2232723quibbled
rabbled123514423_rabbled
rubbed114515083_rubb_ed
rubble104315673_rubble_
rubbles113715113_rubbles
rumbled124514593_rumbled
sabbed114518083s_abb_ed
scabbed14408223scabb_ed
scabble13168653scabble_
scabbles14167983scabbles
scrabbled16154973scrabbled
scribbled16174033scribbled
scrubbed1533853scrubb_ed
scubaed1236123scu_baed
scuffled17256203scuffled
sculled102911693scu_lled
scumble1337013scumble_
scumbles1447023scumbles
scuttled1134533scuttled
shambled16156153shambled
shuffled18296243shuffled
shuttled1234673shuttled
skulled12317403sku_lled
slabbed12409503slabb_ed
slubber113010763slubb_er
slubbered14175253slubbered
smuggled13254223smuggled
snibbed12325633snibb_ed
snubber11277733snubb_er
snubbier1244993snubbier
snuffled15277033snuffled
snuggled11234953snuggled
sobbed113516263s_obb_ed
souffled15276193souffled
souled75419823sou__led
squabble2143883squabble_
squabbler2242733squabbler
squabbles2243633squabbles
squalled1835943squalled
squealed1885353squealed
squibbed2283423squibbed
stabber113610153stabb_er
stabile9312063stabile_
stabiles10311403stabiles
stable83921643st_able_
stabler94014933st_abler
stables93219073st_ables
staled74728103st__aled
stalled83515683st_alled
stapled103613703st_apled
startled9208563startled
steeled83513213st_eeled
steepled1135893steepled
stickled15298973stickled
stifled113511093st_ifled
stilled83314783st_illed
stippled1345303stippled
stipuled1134453stipuled
stoled74521593st__oled
stooled84313893st_ooled
stoppled1345003stoppled
streeled9267863streeled
strolled937813strolled
struggled12304303struggled
stubbiest1345483stubbiest
stubbily1564243stubbily
stubbing13237453stubbing
stubbliest1453343stubbliest
stubborn1242883stubborn
stubby1345043stubb__y
stuccoed1352853stuccoed
studded10236873stu_dded
studied9268693stu_died
stuffed14328973stu_ffed
stumblers1334383stumblers
stummed12348553stu_mmed
stumped124210153stu_mped
stunned8358893stu_nned
stunted83010403stu_nted
sturdied10215963sturdied
styled105613103st__yled
suable83920553s_uable_
subbreed1345873s_ubbreed
subdued11107113s_ubdued
sublet82827243s_u_blet
subtle82113433s_ubtle_
subtler92910843s_ubtler
suckled144212513s_uckled
suppled1248463s_uppled
swabbed15367403swabb_ed
swobbed15335443swobb_ed
symboled1644493symboled
tabbed114215363_tabb_ed
tabbied12297793_tabbied
tabled94020043_t_abled
trebled1038483_trebled
tubber104313203_tubb_er
tubbier11237743_tubbier
tubed85818043_tu_b_ed
tubule839853_tubule_
tubules9310233_tubules
tumble103215643_tumble_
tumbler113412823_tumbler
tumbles113816023_tumbles
turtled8309683_turtled
tussled835413_tussled
wabbled153311443_wabbled
wobbled15349593_wobbled

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621737.02020820.8
3Display Results1731730.0602883.3
 (SQL Overall)1786911737.48323879.6
 
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.