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

186 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
stubbles123684(None) 
stubble1136841stubble_
stubbled1385071stubbled
stumbles1237491stumbles
bubbles104315962_bubbles
nubbles113412432_nubbles
rubbles113715112_rubbles
scabbles14167982scabbles
scumbles1447022scumbles
squabbles2243632squabbles
stabiles10311402stabiles
stables93219072st_ables
stubbed12378082stubb_ed
stubbier1235352stubbier
stubbiest1345472stubbiest
stubblier1343202stubblier
stubbliest1453332stubbliest
stubbly1444472stubbl_y
stumble1147552stumble_
stumbled1335622stumbled
stumbler1235812stumbler
stumblers1334372stumblers
tubules9310232_tubules
tumbles113816022_tumbles
abubble1044523abubble_
babbles104416323_babbles
baubles113611863bau_bles
bobbles104514913_bobbles
brabbles11349753brabbles
bubales113513343_bubales
bubbies103913513_bubbies
bubble94016593_bubble_
bubbled113612123_bubbled
bubbler103611783_bubbler
bubblers11448943_bubblers
bubblies1166773_bubblies
bumbles134016843_bumbles
burbles114916803_burbles
cobbles133814823_cobbles
crumbles14329683crumbles
cubbies133312883_cubbies
dabbles124514773_dabbles
dibbles124013333_dibbles
doubles103113353dou_bles
drabbles13308523drabbles
dribbles13348393dribbles
drumbles13277723drumbles
fribbles15287713fribbles
fumbles143514413_fumbles
gabbles124415413_gabbles
gobbles123512583_gobbles
grabbles13339893grabbles
gribbles13307363gribbles
grumbles13288873grumbles
hobbles143313783_hobbles
hubbies143211563_hubbies
humbles143215803_humbles
jubiles16289373_jubiles
jumbles183013323_jumbles
kibbles153510253_kibbles
mumbles133014433_mumbles
nibbles114011693_nibbles
nobbles114014523_nobbles
nubble103813713_nubble_
numbles113814273_numbles
pebbles1337573_pebbles
quibbles2134223quibbles
rabbles113517973_rabbles
roubles93413503rou_bles
rubbies114114113_rubbies
rubble104315673_rubble_
rubbled124611623_rubbled
rubles83921703_ru_bles
rumbles114018393_rumbles
sables85026693s__ables
scabble13168653scabble_
scabbled15156303scabbled
scrabbles15206283scrabbles
scribbles15184953scribbles
scuffles16287853scuffles
scumble1337013scumble_
scumbled1535053scumbled
scuttles1056503scuttles
shambles15159043shambles
shuffles17297773shuffles
shuttles1136543shuttles
slubbed12339283slubb_ed
slubber113010763slubb_er
slubbers12349943slubbers
smuggles12225443smuggles
snubbed12347443snubb_ed
snubber11277733snubb_er
snubbers12326673snubbers
snubbier1244993snubbier
snubbiest1345063snubbiest
snuffles14318403snuffles
snuggles10306133snuggles
solubles1065893solubles
soubises10107993soubises
souffles14298113souffles
spurtles1037783spurtles
squabble2143883squabble_
squabbled2342563squabbled
squabbler2242733squabbler
squabblers2341843squabblers
stabbed123510373stabb_ed
stabber113610153stabb_er
stabbers12268723stabbers
stabile9312063stabile_
stable83921643st_able_
stabled103514953st_abled
stabler94014933st_abler
stablers103611143st_ablers
stablest103312943st_ablest
staddles10258693staddles
stales65538293st__ales
staples93617213st_aples
startles82111963startles
steeples1038013steeples
steles63725663st__eles
stibines1038143stibines
stickles142512103stickles
stifles103013383st_ifles
stiles64328763st__iles
stipples1247023stipples
stipules1037053stipules
stobbed12287493stobb_ed
stoles63927673st__oles
stopples1236953stopples
storables1146283storables
strobes93813263strob_es
strobiles1146953strobiles
struggles11255283struggles
stubbily1564243stubbily
stubbing13237453stubbing
stubborn1242873stubborn
stubby1345043stubb__y
stubs75016073stu_b__s
stuccoes1254273stuccoes
studdies10207073studdies
studies82413863stu_dies
stuffless1543523stuffless
stulls63912973stu__lls
stupes84116953stu__pes
sturdies92110273sturdies
styles94418653st__yles
suable83920553s_uable_
subbase1139323s_ubbase
subbases1239063s_ubbases
subbass1138033s_ubbass
subbed114116673s_ubb_ed
subdues1099883s_ubdues
subfiles131710713s_ubfiles
sublet82827243s_u_blet
sublets92616703s_u_blets
subrules1039723s_ubrules
subsales10310123s_ubsales
subtle82113433s_ubtle_
subtler92910843s_ubtler
subtlest10511353s_ubtlest
suckles134516743s_uckles
supples11511283s_upples
swabbies15115713swabbies
tabbies112913503_tabbies
tables84524883_t_ables
trebles9311443_trebles
tubbed114712223_tubb_ed
tubber104313203_tubb_er
tubbers113411243_tubbers
tubbier11237743_tubbier
tubbiest12117293_tubbiest
tubeless1037023_tubeless
tubes74826453_tu_b_es
tubule839853_tubule_
tuilles72411923_tuilles
tules54532793_tu__les
tulles63218893_tu_lles
tumble103215643_tumble_
tumbled123412243_tumbled
tumbler113412823_tumbler
tumblers123110623_tumblers
turtles72914343_turtles
tussles737833_tussles
umbles103817493__umbles
wabbles144013993_wabbles
wobbles143412433_wobbles

Search took 9 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.1531167915.0
2DLD Change Limit1461621868.62616944.4
3Display Results1861860.0632952.4
 (SQL Overall)1786911868.84220209.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.