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

197 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
stubble113684(None) 
stubbled1385071stubbled
stubbles1236841stubbles
stubbly1444471stubbly
stumble1147551stumble
abubble1044522abubble
bubble94016592_bubble
nubble103813712_nubble
rubble104315672_rubble
scabble13168652scabble
scumble1337012scumble
squabble2143882squabble
stabile9312062stabile
stable83921642st_able
stubbed12378082stubbed
stubbier1235352stubbier
stubbily1564242stubbily
stubblier1343202stubblier
stubby1345042stubb_y
stumbled1335622stumbled
stumbler1235812stumbler
stumbles1237492stumbles
suable83920552s_uable
subtle82113432s_ubtle
tubule839852_tubule
tumble103215642_tumble
babble94017113_babble
bauble103813213bau_ble
bobble94115143_bobble
brabble10349973brabble
bubale104014623_bubale
bubbled113612123_bubbled
bubbler103611783_bubbler
bubbles104315963_bubbles
bubbly124110353_bubbly
bumble124216893_bumble
burble104617703_burble
clubable1436093clubable
cobble123615263_cobble
crumble133410403crumble
dabble114515193_dabble
dibble114013843_dibble
double94013993dou_ble
drabble12238883drabble
dribble12368603dribble
drumble12337893drumble
equable1849253equable
fribble14287783fribble
fumble133214263_fumble
gabble113815723_gabble
gobble113512983_gobble
grabble12339643grabble
gribble12297273gribble
grumble12349233grumble
hobble133913433_hobble
hubbly16478413_hubbly
humble133615053_humble
issuable1046873issuable
jubile152910263_jubile
jumble174012653_jumble
kibble143910953_kibble
mumble123614343_mumble
mutable11312303mutable
nibble103713283_nibble
nobble103814313_nobble
nubbles113412433_nubbles
nubbly13369673_nubbly
nubile83212713_nubile
pebble1238003_pebble
quibble2034713quibble
rabble103818243_rabble
rouble83913313rou_ble
rubbled124611623_rubbled
rubbles113715113_rubbles
rubbly133710613_rubbly
ruble74521253_ru_ble
rumble103718813_rumble
sable74732163s__able
salable91415463salable
satiable10310733satiable
saturable1146633saturable
savable121711863savable
sayable121411613sayable
scabbled15156303scabbled
scabbles14167983scabbles
scrabble14196993scrabble
scribble14175433scribble
scuffle15266893scuffle
scumbled1535053scumbled
scumbles1447023scumbles
scuttle936463scuttle
seeable91113943seeable
sewable121911173sewable
shamble14149263shamble
shuffle16276923shuffle
shuttle1046103shuttle
sizable1839893sizable
skiable1338883skiable
slubbed12339283slubbed
slubber113010763slubber
smuggle11265013smuggle
snubbed12347443snubbed
snubber11277733snubber
snubbier1244993snubbier
snubby1344533snubb_y
snuffle13267833snuffle
snuggle9275713snuggle
soluble966103soluble
sorbable1239303sorbable
soubise9118793soubise
souffle13306803souffle
sowable121610753sowable
spurtle937453spurtle
squabbled2342563squabbled
squabbler2242733squabbler
squabbles2243633squabbles
stabbed123510373stabbed
stabber113610153stabber
stabiles10311403stabiles
stabled103514953st_abled
stabler94014933st_abler
stables93219073st_ables
stably113314123st_ably
staddle9288093staddle
stale55637103st__ale
staple84415823st_aple
startle72511123startle
statable10310703statable
steeple937323steeple
stele55026843st__ele
sterile7316603sterile
stewable1337133stewable
stibine938663stibine
stickle132410973stickle
stifle93611903st_ifle
stile54931573st__ile
stipple1146623stipple
stipule936723stipule
stobbed12287493stobbed
stole54928813st__ole
stonable1039843stonable
stopple1156583stopple
storable10310733storable
stowable1337613stowable
strobe84513813strob_e
strobile1047033strobile
struggle10345053struggle
stub66221843stu_b__
stubbiest1345483stubbiest
stubbing13237453stubbing
stubbliest1453343stubbliest
stubborn1242883stubborn
stubs75016073stu_b_s
studdie9195273studdie
studly10397693stu_dly
stull54916273stu__ll
stulls63912983stu_lls
stumblers1334383stumblers
stupe75217753stu__pe
style85519363st__yle
suably112814533s_uably
subbase1139323s_ubbase
subbed114116673s_ubbed
subdue9128493s_ubdue
subfile122010503s_ubfile
sublet82827243s_u_blet
subrule939643s_ubrule
subsale9310543s_ubsale
subtile91912623s_ubtile
subtler92910843s_ubtler
subtly11249263s_ubtly
suckle124015963s_uckle
supple10410203s_upple
swabbie1484333swabbie
table75429603_t_able
treble8311663_treble
tubae74716643_tu_bae
tubal75517203_tubal_
tubate82813173_tubate
tubbable1134683_tubbable
tubbed114712223_tubbed
tubber104313203_tubber
tubbier11237743_tubbier
tubby124511403_tubb_y
tube65828663_tu_b_e
tubules9310233_tubules
tuille63012643_tuille
tule45735873_tu__le
tulle54019933_tu_lle
tumbled123412243_tumbled
tumbler113412823_tumbler
tumbles113816023_tumbles
tunable92511313_tunable
turtle63213573_turtle
tussle637143_tussle
wabble133714843_wabble
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 Limit1340271976.73319906.0
3Display Results1971970.0802462.5
 (SQL Overall)1786911977.21924752.9
 
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.