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

232 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
stubby134504(None) 
snubby1344531snubby
stubbly1444471stubbly
tubby124511401_tubby
bubby115013932_bubby
chubby1844122chubby
clubby1534682clubby
cubby145212122_cubby
grubby14324502grubby
hubby155011402_hubby
knubby1742782knubby
nubby125011032_nubby
rubby124413862_rubby
scabby1535502scabby
scrubby1642802scrubby
shabby1635802shabby
shrubby1742362shrubby
slobby1334802slobby
snobby1334402snobby
squabby2343282squabby
stably113314122stably
stub66221842stu_b_
stubbed12378082stubbed
stubbily1564242stubbily
stubble1136842stubble
stubs75016072stu_bs
studly10397692studly
study94411792stu_dy
stuffy15317082stuffy
stumpy13458132stumpy
sturdy1037042sturdy
swabby1634352swabby
tabby125213892_tabby
blabby1234813blabby
blebby1233743blebby
bobby114814663_bobby
brumby15385953brumby
bubba84311803_bubba
bubbly124110353_bubbly
busby126113293_busby
cabby145314563_cabby
cobby145516413_cobby
crabby15346753crabby
crumby15408113crumby
daubry12445483daubry
dauby115211223dau_by
dobby136013633_dobby
doubly12328963doubly
estuary1034683estuary
flabby1634573flabby
fubsy13589273_fubsy
gabby135512953_gabby
globby1434683globby
grabby14336183grabby
hobby155913733_hobby
hubbly16478413_hubbly
knobby1732713knobby
lobby125113923_lobby
nobby125513463_nobby
nubbly13369673_nubbly
outbuy1146943outbuy
outby10411533_outby
ribby12419683_ribby
rubbly133710613_rubbly
ruby97819943_ru_by
rugby11448133_rugby
saucy104615163sau_cy
saughy13507463saughy
saury84317223sau_ry
scuba94211593scu_ba
scubas103710223scubas
scummy15265223scummy
scurfy14338763scurfy
scurry11419593scurry
scurvy14386103scurvy
scuzzy1933083scuzzy
sibb85921433s_ibb_
sibbs96211903s_ibbs
skunky12436163skunky
slub65428033slu_b_
slubbed12339283slubbed
slubber113010763slubber
slubs74719533slu_bs
sludgy11366253sludgy
sluicy1166483sluicy
slummy13325863slummy
slurb74116323slurb_
slurbs8439743slurbs
slurry9378603slurry
slushy12417223slushy
slutty9248003slutty
smudgy13294133smudgy
smugly1274833smugly
smutty11266323smutty
snub65320763snu_b_
snubbed12347443snubbed
snubber11277733snubber
snubs75412553snu_bs
snuffy15356243snuffy
snugly1055663snugly
solubly1255283solubly
soupy106115403sou_py
sourly93612213sourly
spumy124610363spu_my
spunky15427163spunky
spurry11429123spurry
squab163810733squab_
squabs17429323squabs
squib163710503squib_
squibs17317453squibs
stab67329933st_ab_
stabbed123510373stabbed
stabber113610153stabber
stable83921643stable
stabs76221383st_abs
stagey105915583stagey
staggy115510393staggy
stagy96618893st_agy
stalky13499303stalky
standby1334423standby
starry94911673starry
stay78333723st__ay
steady103510203steady
steamy115112373steamy
steely93612573steely
stemmy13417033stemmy
stewy116112063st_ewy
stey76224413st__ey
sticky154711343sticky
stilly93714093stilly
stimy105114743st_imy
stingy105213203stingy
stinky134611073stinky
stithy12398213stithy
stob66724613st_ob_
stobbed12287493stobbed
stobs75718233st_obs
stocky15369153stocky
stodgy11415733stodgy
stogey105811543stogey
stogy95414083st_ogy
stoney96217353stoney
stony85818643st_ony
storey95217613storey
stormy115510733stormy
story86723033st_ory
stoury9529943stoury
stoutly1035833stoutly
strawy1210312823strawy
stray88525573st_ray
stripy115812743stripy
strobe84513813strobe
stroy87720393st_roy
stubbier1235353stubbier
stubbing13237453stubbing
stubbled1385073stubbled
stubbles1236843stubbles
stubborn1242883stubborn
stucco1044253stucco
stuck114515773stu_ck
stud56220093stu__d
studio7247133studio
studs64415873stu_ds
stuff113817053stu_ff
stuffs123810223stuffs
stull54916273stu_ll
stulls63912983stulls
stum65526023stu__m
stumble1147553stumble
stump94616463stu_mp
stumps104912283stumps
stums75320083stu_ms
stun45623453stu__n
stung65417153stu_ng
stunk94616293stu_nk
stuns54719493stu_ns
stunt55328173stu_nt
stunts65615253stunts
stupa74112313stu_pa
stupas83910883stupas
stupe75217753stu_pe
stupefy1542903stupefy
stupes84116953stupes
stupid937593stupid
stupor836013stupor
sturt56028963stu_rt
sturts63915143sturts
sty66227313st___y
stymy13358293st_ymy
suably112814533suably
sub55445553s_u_b_
suba64926603s_u_ba
subah106015213s_ubah
subas74724073s_ubas
subbed114116673s_ubbed
suber74924503s_uber
subs66037123s_u_bs
subtly11249263s_ubtly
subway1447073s_ubway
sucky144415503s_ucky
sudsy95010683s_udsy
suety85318493s_uety
sulky124715363s_ulky
sully84622903s_ully
sunny84917743s_unny
surfy115319473s_urfy
surgy95118523s_urgy
surly85124433s_urly
toby96322293_t_oby
tsuba745563tsu_ba
tub55640033_tu_b_
tuba65422363_tu_ba
tubae74716643_tubae
tubal75517203_tubal
tubas75119583_tubas
tubbed114712223_tubbed
tubber104313203_tubber
tube65828663_tu_be
tubed85818043_tubed
tuber75420683_tuber
tubes74826453_tubes
tubs65430063_tu_bs
tufty114810413_tufty
tummy124711993_tummy
tunny86515033_tunny
turbo71015043_turbo
turfy114315403_turfy
tushy114212993_tushy
tutty85217023_tutty
upby1139063__upby
webby1537153_webby
yabby15389753_yabby

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127162325.07622205.7
3Display Results2322320.0633682.5
 (SQL Overall)1786912325.53232301.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.