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

223 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
slays8572368(None) 
clays105521331clays
flays116321051flays
lays76043251_lays
plays106320771plays
says75942101s_ays
shays116021431shays
slabs75322641slabs
slags66525901slags
slams74927901slams
slaps76025711slaps
slats55436901slats
slaws85222711slaws
slay76436381slay_
spays105520511spays
splays114910871splays
stays86022021stays
sways115518461sways
alans55636172alans
alas46358122ala_s
allays94313742allays
always12409132always
assays977902assays
ays67050292__ays
bays97143912_bays
belays114313852belays
blabs95619632blabs
blahs105616512blahs
blams95023852blams
blats75132502blats
blaws105620462blaws
brays106723112brays
cays95437672_cays
chays135319742chays
clads85722732clads
clags85621122clags
clams95127672clams
clans75031012clans
claps95626182claps
class75525482class
claws106020832claws
clay95927412clay_
cloys104916942cloys
days87637132_days
delays104014052delays
drays95819772drays
elans55527752elans
essays965652essays
fays108535362_fays
flabs105818642flabs
flags95321282flags
flams105125012flams
flans85327972flans
flaps105621382flaps
flats86429742flats
flaws115920342flaws
flay106332802flay_
fleys117015602fleys
frays116920102frays
gays87338022_gays
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
gleys96514852gleys
grays95621332grays
hays106138072_hays
inlays9389872inlays
jays146328342_jays
kays116032192_kays
labs67145122_labs
lacs66942482_lacs
lads56549132_lads
lags56546222_lags
lams66552262_lams
laps66848872_laps
lars46956572_lars
las37281472_la_s
lass47444542_lass
lats45962702_lats
lavs76734152_lavs
laws76441682_laws
lay68865352_lay_
leys76430182_leys
mays96940022_mays
mislays12349242mislays
nays75931592_nays
ofays11488922ofays
okays12609442okays
onlays9398712onlays
pays95940222_pays
plans75731272plans
plats75531372plats
platys11459852platys
play95928982play_
playa105812942playa
playas114612282playas
ploys105816592ploys
prays105022432prays
quays174612042quays
rays77642352_rays
relays94316752relays
sabs66643742s_abs
sacs65739072s_acs
sags55948402s_ags
salads75316962salads
salals65120082salals
sales56055592sales
salps74423242salps
sals46851672s_als
salts55431882salts
sans45153352s_ans
saps65346372s_aps
sass45035622s_ass
satays94411682satays
saws75839482s_aws
say67264762s_ay_
sayst85322002s_ayst
scabs94818642scabs
scads85419952scads
scags85520972scags
scams94423972scams
scans74625102scans
scars75433532scars
scats75930602scats
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seats54844342seats
selahs9313212selahs
shads95124482shads
shags95123862shags
shahs115919512shahs
shams105829412shams
shaws116226262shaws
shay107133342shay_
sials54227242sials
skags104316072skags
skas85325712ska_s
skats94621532skats
slab67133762sla_b
slack115021762slack
slacks124416532slacks
slag55934352sla_g
slain54923572slain
slake93724052slake
slakes104021882slakes
slam67737972sla_m
slang66324022slang
slangs75615342slangs
slank95822772slank
slant55238702slant
slants64819082slants
slap66434042sla_p
slash84719682slash
slat46959022sla_t
slate55438282slate
slates64934062slates
slaty86523152slaty
slave84224032slave
slaves95023022slaves
slaveys13415202slaveys
slaw77930712sla_w
slayed104716222slayed
slayer93916332slayer
slayers104513322slayers
sleds64418852sleds
slews86220352slews
slims75423652slims
slips76023722slips
slits56128852slits
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
slops75026012slops
slots54830522slots
slows85323462slows
sloyd9409682sloyd
sloyds10346292sloyds
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slums74623432slums
slurs54123372slurs
sluts54523982sluts
sly66228562sl_y_
snags64421312snags
snaps74719562snaps
snaws86116362snaws
soaks95220292soaks
soaps75120712soaps
soars54732512soars
solans64122492solans
soyas84520912soyas
soys75233932s_oys
spaes76029972spaes
spams94922192spams
spans74528732spans
spars75431542spars
spas67036722spa_s
spats75031382spats
spay96631662spay_
splats84817302splats
splay105816042splay_
sprays115913642sprays
stabs76221382stabs
stags66226742stags
stars55836572stars
stats55933362stats
stay78333722stay_
strays96417932strays
swabs105817272swabs
swags94921252swags
swans84625012swans
swaps104819202swaps
swats85726862swats
sway107128232sway_
trays85623432trays
ulans54921302ulans
unlays93810492unlays
ways107737952_ways
yays105728912_yays

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.0931921408.6
2DLD Change Limit538002231.78330173.9
3Display Results2232230.0633539.7
 (SQL Overall)1786912231.93992156.3
 
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.