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

179 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
slob6602942(None) 
blob86027091blob
glob76623391glob
lob57154461_lob
slab67133761slab
slobs74419871slobs
sloe45534951sloe
slog56728271slog
slop66533871slop
slot46049831slot
slow77729491slow
slub65428031slub
snob65825591snob
sob57857941s_ob
stob66724611stob
swob95218631swob
alb57342652al_b
aloe45540192aloe
alow75328592alow
blab86629132blab
bleb85425222bleb
blobs95620032blobs
bloc85023272bloc
blog75723822blog
blot65842322blot
blow95827192blow
blub85324872blub
bob76755672_bob
boob85932582boob
clod76124612clod
clog76123242clog
clomb115714702clomb
clon66232482clon
clop86929892clop
clot66542422clot
cloy96623832cloy
club85819472club
cob710258752_cob
flab96628352flab
floc95922122floc
floe76129772floe
flog85523892flog
flop96925452flop
flow105924922flow
flub95721882flub
fob86748332_fob
glib79421442glib
globe84917012globe
globs85616402globs
glom75424382glom
glop76724632glop
glow85222522glow
gob68950892_gob
hob87550922_hob
job128041772_job
knob107417012knob
kob99442382_kob
lab58864782_lab
lib57750272_lib
lo28053442_lo_
lobe65535362_lobe
lobo67229862_lobo
lobs66441082_lobs
log46252682_log
loo38359822_loo
lop58255312_lop
lot38179262_lot
low66051872_low
lox108240962_lox
mob78651922_mob
nob58954422_nob
pleb86123812pleb
plod76723272plod
plop86625742plop
plot66141232plot
plow95923232plow
ploy96123602ploy
rob56754302_rob
sab56563202s_ab
salol55222142salol
salon55228552salon
scab85926712scab
scop85925522scop
scot66242612scot
scow96021422scow
shlub105411742shlub
shod86225062shod
shoe75933442shoe
shog86025142shog
shoo75929892shoo
shop95629842shop
shot76150262shot
show106229192show
sib56850312s_ib
sibb85921422sibb
silo46037912silo_
silos56029432silos
slabs75322642slabs
slag55934352slag
slam67737972slam
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sled55334372sled
slew76228232slew
slid55828982slid
slim66631962slim
slip67031732slip
slit46250102slit
slobby1334802slobby
sloes54728872sloes
slogs64521842slogs
sloid64619712sloid
slojd13378842slojd
sloop76118912sloop
slope75823562slope
slops75026012slops
slosh84514482slosh
sloth85019452sloth
slots54830532slots
slows85323462slows
sloyd9409682sloyd
slubs74719532slubs
slue45332192slue
slug55124642slug
slum65430512slum
slur45525152slur
slurb74116322slurb
slut45040592slut
sly66228562sl_y
smog76317412smog
snib66522982snib
snobs74716152snobs
snog55623632snog
snot44745452snot
snow76324792snow
snub65320762snub
so28855442s_o_
soba64927922s_oba
sobs64941752s_obs
sod46053702s_od
sol37256622s_ol
sola45541862sola
sold54837412sold
sole46053672sole
soli46637012soli
solo45538942solo
solon55026132solon
solos54830792solos
sols45448162sols
som59153812s_om
son37761952s_on
sook84933392sook
soon46240502soon
soot45761062soot
sop57557862s_op
sorb68333042sorb
sos37761602s_os
sot310384302s_ot
sou37853692s_ou
sow66554762s_ow
sox106444192s_ox
soy67851452s_oy
spot65540692spot
stab67329932stab
stoa45425912stoa
stobs75718232stobs
stop66532032stop
stot46347332stot
stow77325742stow
stub66221842stub
sub55445552s_ub
swab96825312swab
swobs104910892swobs
swop95120502swop
swot75134662swot
sybo9714742sybo
yob87945272_yob

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 Filter178691298720.280638182.1
2DLD Change Limit298721790.92332364.0
3Display Results1791790.0463891.3
 (SQL Overall)1786911791.249143067.3
 
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.