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

208 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
slabs7532264(None) 
blabs95619631blabs
flabs105818641flabs
labs67145121_labs
sabs66643741s_abs
scabs94818641scabs
slab67133761slab_
slags66525901slags
slams74927901slams
slaps76025711slaps
slats55436901slats
slaws85222711slaws
slays85723681slays
slobs74419871slobs
slubs74719531slubs
stabs76221381stabs
swabs105817271swabs
abs59356072__abs
alans55636172alans
alas46358122ala_s
albas75925392albas
albs68628572al_bs
blab86629132blab_
blahs105616512blahs
blams95023852blams
blats75132502blats
blaws105620462blaws
blebs96416152blebs
blobs95620032blobs
blubs95818152blubs
cabs86739422_cabs
clads85722732clads
clags85621122clags
clams95127672clams
clans75031012clans
claps95626182claps
class75525482class
claws106020832claws
clays105521332clays
clubs95415102clubs
crabs95421392crabs
dabs77139402_dabs
drabs85119672drabs
elans55527752elans
fabs98635862_fabs
flab96628352flab_
flags95321282flags
flams105125012flams
flans85327972flans
flaps105621382flaps
flats86429742flats
flaws115920342flaws
flays116321052flays
flubs105515442flubs
gabs76740422_gabs
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
globs85616402globs
grabs85719692grabs
jabs135830092_jabs
kabs107130842_kabs
lab58864782_lab_
lacs66942482_lacs
lads56549132_lads
lags56546222_lags
lambs95921412_lambs
lams66552262_lams
laps66848872_laps
lars46956572_lars
las37281472_la_s
lass47444542_lass
lats45962702_lats
lavs76734152_lavs
laws76441682_laws
lays76043252_lays
libs66732752_libs
lobs66441082_lobs
nabs66236192_nabs
plans75731272plans
plats75531372plats
plays106320772plays
plebs95814582plebs
sab56563202s_ab_
sabe66140572s_abe
sabes76437462s_abes
sacs65739072s_acs
sags55948402s_ags
salads75316962salads
salals65120082salals
sales56055592sales
salps74423242salps
sals46851672s_als
salts55431882salts
sans45153352s_ans
saps65346372s_aps
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scab85926712scab_
scads85419952scads
scags85520972scags
scams94423972scams
scans74625102scans
scars75433532scars
scats75930602scats
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
selahs9313212selahs
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shaws116226262shaws
shays116021432shays
shlubs11386732shlubs
sials54227242sials
sibbs96211892sibbs
sibs65933532s_ibs
skags104316072skags
skas85325712ska_s
skats94621532skats
slack115021762slack
slacks124416532slacks
slag55934352sla_g
slain54923572slain
slake93724052slake
slakes104021882slakes
slam67737972sla_m
slang66324022slang
slangs75615342slangs
slank95822772slank
slant55238702slant
slants64819082slants
slap66434042sla_p
slash84719682slash
slat46959022sla_t
slate55438282slate
slates64934062slates
slaty86523152slaty
slave84224032slave
slaves95023022slaves
slaw77930712sla_w
slay76436382sla_y
sleds64418852sleds
slews86220352slews
slims75423652slims
slips76023722slips
slits56128852slits
slob66029422slob_
sloes54728872sloes
slogs64521842slogs
slops75026012slops
slots54830522slots
slows85323462slows
slub65428032slub_
slues54527172slues
slugs64618562slugs
slums74623432slums
slurbs8439742slurbs
slurs54123372slurs
sluts54523982sluts
snags64421312snags
snaps74719562snaps
snaws86116362snaws
snibs75613752snibs
snobs74716152snobs
snubs75412552snubs
soaks95220292soaks
soaps75120712soaps
soars54732512soars
sobas74424252sobas
sobs64941752s_obs
solans64122492solans
sorbs75022102sorbs
spaes76029972spaes
spams94922192spams
spans74528732spans
spars75431542spars
spas67036722spa_s
spats75031382spats
spays105520512spays
splats84817302splats
splays114910872splays
squabs17429322squabs
stab67329932stab_
stags66226742stags
stars55836572stars
stats55933362stats
stays86022022stays
stobs75718232stobs
stubs75016072stubs
subas74724072subas
subs66037122s_ubs
swab96825312swab_
swags94921252swags
swans84625012swans
swaps104819202swaps
swats85726862swats
sways115518462sways
swobs104910892swobs
tabs66842982_tabs
ulans54921302ulans
wabs97337232_wabs

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.1101624463.6
2DLD Change Limit538002081.70331591.3
3Display Results2082080.0633301.6
 (SQL Overall)1786912081.87695251.1
 
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.