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 “snobs” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

134 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
snobs7471615(None) 
knobs11519711knobs
nobs66436901_nobs
slobs74419871slobs
snibs75613761snibs
snob65825591snob_
snogs66017491snogs
snots55225121snots
snows84719891snows
snubs75412551snubs
sobs64941751s_obs
stobs75718231stobs
swobs104910891swobs
anoas57226492anoas
blobs95620032blobs
bobs86340652_bobs
boobs96221992boobs
cobs87043142_cobs
enols54718402enols
enows85115492enows
fobs96034272_fobs
globs85616402globs
gobs76935572_gobs
hobs97038982_hobs
jobs136529432_jobs
knob107417022knob_
knops115911812knops
knots95614722knots
knows124912412knows
kobs105831092_kobs
lobs66441082_lobs
mobs85737372_mobs
nabs66236192_nabs
nebs66124982_nebs
nibs65028322_nibs
nob58954422_nob_
nods55838232_nods
noes45845392_noes
nogs56534612_nogs
noms65636402_noms
nos38859322_no_s
nous46136982_nous
nows75738232_nows
nubs65927142_nubs
onos46229002ono_s
robs65837872_robs
sabs66643742s_abs
scabs94818642scabs
scops95820192scops
scots74025912scots
scows106617802scows
senors63620792senors
shoes85429662shoes
shogs95319712shogs
shoos84226362shoos
shops104222902shops
shots84730852shots
shows115324582shows
sibbs96211902sibbs
sibs65933552s_ibs
slabs75322642slabs
slob66029422slob_
sloes54728872sloes
slogs64521842slogs
slops75026012slops
slots54830532slots
slows85323462slows
slubs74719532slubs
smogs85112162smogs
snags64421312snags
snaps74719562snaps
snaws86116362snaws
sneds65715352sneds
snib66522982snib_
snips75818012snips
snits54124832snits
snobby1334402snobby
snog55623632sno_g
snood64616162snood
snoods74312452snoods
snook95115572snook
snooks104412832snooks
snool55118642snool
snools65715882snools
snoop75317172snoop
snoops84314172snoops
snoot55030142snoot
snoots64216682snoots
snore55424952snore
snores64324322snores
snort54833752snort
snorts64116502snorts
snot44745452sno_t
snout54530632snout
snouts64915872snouts
snow76324792sno_w
snowy115011562snowy
snub65320762snub_
snugs64913022snugs
snyes85012752snyes
sob57857942s_ob_
soba64927922s_oba
sobas74424252s_obas
sods54940222s_ods
sols45448162s_ols
soms66239372s_oms
sones55444142sones
songs67725552songs
sons46049552s_ons
sooks94425452sooks
soots55536212soots
sops65244562s_ops
sorbs75022102sorbs
sos37761602s_o_s
sots45552452s_ots
sous46947212s_ous
sows75342492s_ows
soys75233932s_oys
spots74424112spots
stabs76221382stabs
stoas55126022stoas
stob66724612stob_
stops74827282stops
stoss54316342stoss
stots54828552stots
stows86622702stows
stubs75016072stubs
subs66037122s_ubs
swabs105817272swabs
swob95218632swob_
swops105913972swops
swots85518432swots
synods1077952synods
yobs96028082_yobs

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit538001341.59333772.8
3Display Results1341340.0334060.6
 (SQL Overall)1786911341.95291542.5
 
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.