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

120 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
knobby173271(None) 
knobbly1842871knobbly
knubby1742781knubby
nobby125513461_nobby
snobby1334401snobby
bobby114814662_bobby
cobby145516412_cobby
dobby136013632_dobby
globby1434682globby
hobby155913732_hobby
knob107417012kno_b_
knobbed1633712knobbed
knobs11519712kno_bs
knolly13336132knolly
knotty13315222knotty
lobby125113922_lobby
nobly105314402_nobly
nubby125011032_nubby
slobby1334802slobby
snubby1344532snubby
anomy105113393ano_my
blabby1234813blabby
blebby1233743blebby
blowby16467513blowby
booby125319513_booby
bubby115013933_bubby
cabby145314563_cabby
chubby1844123chubby
clubby1534683clubby
cobb106422003_cobb_
cobbs115013993_cobbs
colby124415063_colby
corby125018533_corby
crabby15346753crabby
cubby145212123_cubby
doby106022163_do_by
flabby1634573flabby
forby135317673_forby
gabby135512953_gabby
goby106021083_go_by
goodby13406283goodby
grabby14336183grabby
grubby14324503grubby
hubby155011403_hubby
ignobly1342873ignobly
inby95315663in__by
kabob134113933kabob_
kabobs14439303kabobs
kebob135110923kebob_
kebobs14427293kebobs
kibbe135211973k_ibbe
kibbi13449273k_ibbi
knarry1334613knarry
knobbier1652703knobbier
knock10487963kno_ck
knocks11397443knocks
knoll9389603kno_ll
knolls10367413knolls
knop107116593kno__p
knops115911813kno_ps
knosp11576823kno_sp
knosps12405013knosps
knot85630503kno__t
knots95614723kno_ts
knout95018263kno_ut
knouts10438313knouts
know116115843kno__w
knower1337083knower
known12568343kno_wn
knowns13426443knowns
knows124912413kno_ws
knurly13405533knurly
kob99442383k_o_b_
kobo107422103k_o_bo
kobos115616893k_obos
kobs105831083k_o_bs
kombu1347243k_ombu
kooky114412873k_ooky
looby108115623_looby
nob58954423_no_b_
nobbily1436693_nobbily
nobble103814313_nobble
noble74420993_noble
nobody1235743_nobody
nobs66436903_no_bs
noddy105411203_noddy
noily86120993_noily
noisy86813363_noisy
nooky124814813_nooky
nosey85619883_nosey
nosy76322893_no_sy
noway111112843_noway
nubbly13369673_nubbly
obey96521303__obey
orby97519603__orby
poboy121612223_poboy
ribby12419683_ribby
rubby124413863_rubby
scabby1535503scabby
shabby1635803shabby
snob65825593sno_b_
snobbery15514293snobbery
snobbily1544233snobbily
snobs74716153sno_bs
snoopy11449473snoopy
snooty94211513snooty
snoozy18517233snoozy
snotty9489203snotty
snouty9419953snouty
snowy115011563sno_wy
stubby1345043stubby
swabby1634353swabby
tabby125213893_tabby
toby96322293_to_by
tubby124511403_tubby
webby1537153_webby
wobbly16347093_wobbly
womby155910093_womby
yabby15389753_yabby
yobbo1237873_yobbo

Search took 10 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.670266703.0
2DLD Change Limit1127161208.48613282.6
3Display Results1201200.0631904.8
 (SQL Overall)1786911209.21919382.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.