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

137 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
stubbly144447(None) 
stubbily1564241stubbily
stubble1136841stubble
stubby1345041stubb_y
bubbly124110352_bubbly
hubbly16478412_hubbly
nubbly13369672_nubbly
rubbly133710612_rubbly
snubby1344532snubb_y
stably113314122st_ably
stubbed12378082stubbed
stubbled1385072stubbled
stubbles1236842stubbles
studly10397692stu_dly
stumble1147552stumble
suably112814532s_uably
subtly11249262s_ubtly
tubby124511402_tubb_y
abubble1044523abubble
astutely1153643astutely
bubble94016593_bubble
bubby115013933_bubb_y
burbly134311153_burbly
chubbily2042913chubbily
chubby1844123chubb_y
clubby1534683clubb_y
crumbly16347523crumbly
cubby145212123_cubb_y
doubly12328963dou_bly
dribbly15274953dribbly
dumbly14399603_dumbly
equably2136183equably
grubbily1642973grubbily
grubby14324503grubb_y
grumbly15355403grumbly
hubby155011403_hubb_y
humbly164010523_humbly
issuably1344963issuably
knobbly1842873knobbly
knubby1742783knubb_y
mumbly15319463_mumbly
mutably1438613mutably
nubble103813713_nubble
nubby125011033_nubb_y
numbly134410663_numbly
pebbly1545083_pebbly
rubble104315673_rubble
rubby124413863_rubb_y
rumbly134412163_rumbly
salably121610743salably
satiably1337823satiably
saucily1237913saucily
scabbily1763943scabbily
scabble13168653scabble
scabby1535503scabb_y
scrabbly17164623scrabbly
scribbly17143623scribbly
scrubbily1842313scrubbily
scrubby1642803scrubb_y
scumble1337013scumble
shabbily1873903shabbily
shabby1635803shabb_y
shrubby1742363shrubb_y
sizably2136613sizably
slobby1334803slobb_y
slubbed12339283slubbed
slubber113010763slubber
smugly1274833smu_gly
snobbily1544233snobbily
snobby1334403snobb_y
snubbed12347443snubbed
snubber11277733snubber
snuffly16305193snuffly
snugly1055663snu_gly
solubly1255283solubly
soundly1136683soundly
sourly93612203sou_rly
squabble2143883squabble
squabby2343283squabby
squally1937663squally
squatly1946423squatly
stabbed123510373stabbed
stabber113610153stabber
stabile9312063stabile
stable83921643st_able
stagily1139053stagily
staidly1136683staidly
stalely1039213stalely
starkly14277033starkly
stately10310223stately
steely93612573st_eely
steeply1236293steeply
sternly1037853sternly
stiffly16235173stiffly
stilly93714073st_illy
stobbed12287493stobbed
stonily1049433stonily
stoutly1035833stoutly
stub66221843stu_b__
stubbier1235353stubbier
stubbing13237453stubbing
stubblier1343203stubblier
stubborn1242873stubborn
stubbornly175893stubbornly
stubs75016073stu_b_s
study94411793stu__dy
stuffily17124163stuffily
stuffy15317083stu_ffy
stull54916273stu__ll
stulls63912973stu_lls
stumbled1335623stumbled
stumbler1235813stumbler
stumbles1237493stumbles
stumpy13458133stu_mpy
stupefy1542903stupefy
stupidly1442633stupidly
sturdily1245073sturdily
sturdy1037043stu_rdy
suable83920553s_uable
subbed114116673s_ubbed
subtle82113433s_ubtle
subway1447073s_ubway
sully84622893s_u_lly
supply1346893s_upply
surely93816453s_urely
surly85124423s_u_rly
swabby1634353swabb_y
tabby125213893_tabb_y
trebly1138973_trebly
tubal75517203_tubal_
tubbed114712223_tubbed
tubber104313203_tubber
tubule839853_tubule
tumble103215643_tumble
tunably12218293_tunably
wabbly16348363_wabbly
wobbly16347093_wobbly

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.203880251.2
2DLD Change Limit1340271377.12618808.2
3Display Results1371370.0632174.6
 (SQL Overall)1786911377.39224173.6
 
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.