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

182 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
snubby134453(None) 
knubby1742781knubby
nubby125011031_nubby
snobby1334401snobby
stubby1345041stubby
bubby115013932_bubby
chubby1844122chubby
clubby1534682clubby
cubby145212122_cubby
grubby14324502grubby
hubby155011402_hubby
knobby1732712knobby
nobby125513462_nobby
nubbly13369672_nubbly
rubby124413862_rubby
scabby1535502scabby
scrubby1642802scrubby
shabby1635802shabby
shrubby1742362shrubby
slobby1334802slobby
snub65320762snu_b_
snubbed12347442snubbed
snubber11277732snubber
snubs75412552snu_bs
snuffy15356242snuffy
snugly1055662snugly
squabby2343282squabby
stubbly1444472stubbly
swabby1634352swabby
tubby124511402_tubby
blabby1234813blabby
blebby1233743blebby
bobby114814663_bobby
brumby15385953brumby
bubba84311803_bubba
bubbly124110353_bubbly
busby126113293_busby
cabby145314563_cabby
cobby145516413_cobby
crabby15346753crabby
crumby15408113crumby
daubry12445483daubry
dauby115211223dau_by
dobby136013633_dobby
doubly12328963doubly
flabby1634573flabby
fubsy13589273_fubsy
gabby135512953_gabby
globby1434683globby
grabby14336183grabby
hobby155913733_hobby
hubbly16478413_hubbly
inby95315663in__by
knobbly1842873knobbly
knurly13405533knurly
lobby125113923_lobby
nobly105314403_nobly
nub56439143_nu_b_
nubbin10308293_nubbin
nubble103813713_nubble
nubia7311233_nubia
nubs65927143_nu_bs
numb85520613_numb_
numbly134410663_numbly
numbs94913093_numbs
nutsy85711503_nutsy
nutty84816873_nutty
outby10411533_outby
ribby12419683_ribby
rubbly133710613_rubbly
ruby97819943_ru_by
rugby11448133_rugby
saucy104615163sau_cy
saughy13507463saughy
saury84317223sau_ry
scuba94211593scu_ba
scubas103710223scubas
scummy15265223scummy
scurfy14338763scurfy
scurry11419593scurry
scurvy14386103scurvy
scuzzy1933083scuzzy
sibb85921423s_ibb_
sibbs96211903s_ibbs
skunky12436163skunky
slub65428033slu_b_
slubbed12339283slubbed
slubber113010763slubber
slubs74719533slu_bs
sludgy11366253sludgy
sluicy1166483sluicy
slummy13325863slummy
slurb74116323slurb_
slurbs8439743slurbs
slurry9378603slurry
slushy12417223slushy
slutty9248003slutty
smudgy13294133smudgy
smugly1274833smugly
smutty11266323smutty
snaggy11488053snaggy
snakey135011273snakey
snaky125113913sn_aky
snappy1366103snappy
snarky134210843snarky
snarly93815003snarly
snazzy1734013snazzy
sneaky13427843sneaky
sneery93610413sneery
sneezy18345273sneezy
snib66522983sn_ib_
snibbed12325633snibbed
snibs75613763sn_ibs
sniffy15337193sniffy
snippy1374843snippy
snob65825593sn_ob_
snobbery15514293snobbery
snobbily1544233snobbily
snobs74716153sn_obs
snoopy11449473snoopy
snooty94211513snooty
snoozy18517233snoozy
snotty9489203snotty
snouty9419953snouty
snowy115011563sn_owy
snubbers12326673snubbers
snubbier1244993snubbier
snubbing13236673snubbing
snuck114411913snu_ck
snuff113514043snu_ff
snuffly16305203snuffly
snuffs12358533snuffs
snug55218693snu__g
snugs64913023snu_gs
solubly1255283solubly
soupy106115403sou_py
sourly93612213sourly
spumy124610363spu_my
spunky15427163spunky
spurry11429123spurry
squab163810733squab_
squabs17429323squabs
squib163710503squib_
squibs17317453squibs
stably113314123stably
stub66221843stu_b_
stubbed12378083stubbed
stubbily1564243stubbily
stubble1136843stubble
stubs75016073stu_bs
studly10397693studly
study94411793stu_dy
stuffy15317083stuffy
stumpy13458133stumpy
sturdy1037043sturdy
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
sunbow1145823sunbow
sundry1057943sundry
sunny84917743s_unny
sunray9310123sunray
surfy115319473s_urfy
surgy95118523s_urgy
surly85124433s_urly
tabby125213893_tabby
unbusy1135213unbusy
upby1139063__upby
webby1537153_webby
yabby15389753_yabby

Search took 7 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.390458182.1
2DLD Change Limit1127161825.86019234.8
3Display Results1821820.0463956.5
 (SQL Overall)1786911826.29628381.7
 
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.