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

163 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
slub6542803(None) 
blub85324871blub
club85819471club
flub95721881flub
shlub105411741shlub
slab67133761slab
slob66029421slob
slubs74719531slubs
slue45332191slue
slug55124641slug
slum65430511slum
slur45525151slur
slurb74116321slurb
slut45040591slut
snub65320761snub
stub66221841stub
sub55445551s_ub
alb57342652al_b
alum65227612alum
blab86629132blab
bleb85425222bleb
blob86027092blob
blubs95818152blubs
blue65328462blue
blur66020532blur
blurb95214902blurb
bub76343972_bub
bulb85626692bulb
chub115516412chub
clubs95415102clubs
clue65324532clue
cub76940942_cub
daub77423442daub
drub75920132drub
dub66642202_dub
flab96628352flab
flu66530212flu_
flubs105515442flubs
flue75329852flue
flus75626542flus
flux145617742flux
fub86337392_fub
glib79421432glib
glob76623392glob
glue55628492glue
glug66118012glug
glum75825102glum
glut56331292glut
grub77220082grub
hub86437482_hub
lab58864782_lab
lib57750262_lib
lob57154462_lob
lube64731562_lube
lug46138062_lug
lum55542932_lum
luv67125772_luv
lux106528772_lux
nub56439142_nub
pleb86123812pleb
plug74915992plug
plum85122102plum
plumb114514072plumb
plus66324832plus
pub76037692_pub
rub56342822_rub
sab56563202s_ab
sau36356572sau_
saul45836522saul
scab85926712scab
schlub1355002schlub
scrub94914202scrub
scuba94211592scuba
scud76221282scud
scum85924522scum
scup84822382scup
scut65835542scut
shlubs11386732shlubs
shrub104814892shrub
shul75823152shul
shun75122772shun
shut76137582shut
sib56850302s_ib
sibb85921412sibb
skua86113152skua
slabs75322642slabs
slag55934352slag
slam67737972slam
slap66434042slap
slat46959022slat
slaw77930712slaw
slay76436382slay
sled55334372sled
slew76228232slew
slid55828982slid
slim66631952slim
slip67031732slip
slit46250102slit
slobs74419872slobs
sloe45534952sloe
slog56728272slog
slop66533872slop
slot46049822slot
slow77729492slow
slued64220512slued
slues54527172slues
sluff114016812sluff
slugs64618562slugs
slump94816632slump
slums74623432slums
slung65117832slung
slunk95016302slunk
slurbs8439742slurbs
slurp74014982slurp
slurs54123372slurs
slush85316572slush
sluts54523982sluts
sly66228562sl_y
smug75815262smug
smut66629782smut
snib66522972snib
snob65825592snob
snubs75412552snubs
snug55218692snug
sob57857942s_ob
solum74717602solum
solus54726982solus
sorb68333042sorb
sou37853692sou_
souk86127172souk
soul46435712soul
soup66232912soup
sour45935892sour
sous46947212sous
spud75818492spud
spue66025522spue
spun66221462spun
spur65321192spur
squab163810732squab
squib163710492squib
stab67329932stab
stob66724612stob
stubs75016072stubs
stud56220092stud
stum65526012stum
stun45623452stun
suba64926602s_uba
subs66037122s_ubs
sue35651462s_ue
suk75632972s_uk
sulk85326652sulk
sulu45128422sulu
sulus54821882sulus
sum56346012s_um
sun37149032s_un
sup57041942s_up
suq126228992s_uq
swab96825312swab
swob95218632swob
swum96416822swum
tub55640032_tub
ulu36028702ulu_
ulus45622562ulus

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.0632836365.1
2DLD Change Limit298721630.93631914.5
3Display Results1631630.0463543.5
 (SQL Overall)1786911631.045170996.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.