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

327 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
slats5543690(None) 
blats75132501blats
flats86429741flats
lats45962701_lats
plats75531371plats
salts55431881salts
scats75930601scats
seats54844341seats
skats94621531skats
slabs75322641slabs
slags66525901slags
slams74927901slams
slants64819081slants
slaps76025711slaps
slat46959021slat_
slate55438281slate
slates64934061slates
slaty86523151slaty
slaws85222711slaws
slays85723681slays
slits56128851slits
slots54830521slots
sluts54523981sluts
spats75031381spats
splats84817301splats
stats55933361stats
swats85726861swats
alans55636172alans
alants67722022alants
alas46358122ala_s
alate55340322alate
alates64833962alates
alts46639902al_ts
bats66962332_bats
beats76042242beats
blabs95619632blabs
blahs105616512blahs
blams95023852blams
blast76532572blast
blasts85116772blasts
blat66550952blat_
blate75933782blate
blaws105620462blaws
bleats85518612bleats
blets75324942blets
bloats85215762bloats
blots75626172blots
boats75635152boats
brats75336012brats
cats66356342_cats
chats105730092chats
clads85722732clads
clags85621122clags
clams95127672clams
clans75031012clans
claps95626182claps
class75525482class
clast76030582clast
clasts84817292clasts
claws106020832claws
clays105521332clays
cleats84919312cleats
clots75627642clots
coats75634992coats
doats65224882doats
drats66628372drats
eats47054872_eats
eclats8313032eclats
elans55527752elans
elate55335882elate
elates65032362elates
fats76252502_fats
feats86432752feats
fiats85324482fiats
flabs105818642flabs
flags95321282flags
flams105125012flams
flans85327972flans
flaps105621382flaps
flat77147822flat_
flatus94310782flatus
flaws115920342flaws
flays116321052flays
flits85625222flits
floats96816252floats
frats86829672frats
gats56753442_gats
ghats95818612ghats
glads75620612glads
glams85822932glams
glans65125832glans
glass65518132glass
gloats74515422gloats
gluts66120132gluts
gnats65217712gnats
goats65527302goats
halts85230102halts
hats76858252_hats
heats85838402heats
ikats95311152ikats
islets64513082islets
kats85944332_kats
khats125316012khats
kyats125012442kyats
labs67145122_labs
lacs66942482_lacs
lads56549132_lads
lags56546222_lags
lams66552262_lams
laps66848872_laps
lars46956572_lars
las37281472_la_s
lass47444542_lass
last46260322_last
lasts57731262_lasts
lat37593402_lat_
late47560482_late
lath76640382_lath
laths86022402_laths
lati46438272_lati
latu47934182_latu
lavs76734152_lavs
laws76441682_laws
lays76043252_lays
lets47147942_lets
lits46252492_lits
lots47652092_lots
malts76331752malts
mats65460282_mats
meats75034052meats
moats75827642moats
neats55931902neats
oats46554212_oats
pats66460852_pats
peats76140192peats
plaits83816472plaits
plans75731272plans
plants84921802plants
plat66048872plat_
plate74635112plate
plates85432242plates
platy105021662platy
platys11459852platys
plays106320772plays
pleats85218592pleats
plots75025672plots
prats76333392prats
qats135331342_qats
rats46260372_rats
sabs66643742s_abs
sacs65739072s_acs
sags55948402s_ags
salads75316962salads
salals65120082salals
sales56055592sales
salps74423242salps
sals46851672s_als
salt45758522salt_
salty85524382salty
sans45153352s_ans
saps65346372s_aps
sass45035622s_ass
sat36288482s_at_
sate45556102s_ate
sates54949322s_ates
sati45539322s_ati
satis55633672s_atis
saws75839482s_aws
says75942102s_ays
scabs94818642scabs
scads85419952scads
scags85520972scags
scams94423972scams
scans74625102scans
scants85219722scants
scars75433532scars
scarts85321492scarts
scat65848372scat_
scatt76030092scatt
scatts85914662scatts
scots74025902scots
scuts74522522scuts
seals54839692seals
seams75731662seams
sears54744912sears
seas45755272sea_s
seat47575562seat_
sects75622892sects
selahs9313212selahs
septs75420602septs
sets45549502s_ets
setts55124322setts
sexts125118382sexts
shads95124482shads
shafts125411432shafts
shags95123862shags
shahs115919512shahs
shams105829412shams
shat76456592shat_
shaws116226262shaws
shays116021432shays
shits84731162shits
shoats94117072shoats
shots84730832shots
shuts85622472shuts
sials54227242sials
sifts84918922sifts
silts55330822silts
sits45050202s_its
skags104316072skags
skas85325712ska_s
skat87037892skat_
skate94721542skate
skates104219392skates
skits94721852skits
slab67133762sla_b
slack115021762slack
slacks124416532slacks
slag55934352sla_g
slain54923572slain
slake93724052slake
slakes104021882slakes
slam67737972sla_m
slang66324022slang
slangs75615342slangs
slank95822772slank
slant55238702slant
slanty95114842slanty
slap66434042sla_p
slash84719682slash
slatch114510532slatch
slated75028312slated
slater64429182slater
slaters73123722slaters
slatey95417062slatey
slave84224032slave
slaves95023022slaves
slaw77930712sla_w
slay76436382sla_y
sleds64418852sleds
sleets64318872sleets
slews86220352slews
slims75423652slims
slips76023722slips
slit46250102slit_
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
slops75026012slops
slot46049822slot_
sloth85019442sloth
sloths94911882sloths
slows85323462slows
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slums74623432slums
slurs54123372slurs
slut45040592slut_
smalts85214892smalts
smarts86218002smarts
smuts75415712smuts
snags64421312snags
snaps74719562snaps
snath86419802snath
snaths95112912snaths
snaws86116362snaws
snits54124832snits
snots55225102snots
soaks95220292soaks
soaps75120712soaps
soars54732512soars
softs85019232softs
solans64122492solans
solate64526072solate
solates73523852solates
soots55536202soots
sorts54536662sorts
sots45552442s_ots
spaes76029972spaes
spaits85017472spaits
spams94922192spams
spans74528732spans
spars75431542spars
spas67036722spa_s
spat66548522spat_
spate74731582spate
spates85028172spates
spays105520512spays
spits74429552spits
splat76129342splat_
splays114910872splays
splits85416412splits
spots74424102spots
sprats85819932sprats
squats153712962squats
stabs76221382stabs
stags66226742stags
stars55836572stars
starts65423122starts
stat47352692stat_
state56237332state
states64337082states
status65515212status
stays86022022stays
stets55423912stets
stoats65117482stoats
stots54828542stots
suets55126102suets
suits55028052suits
swabs105817272swabs
swags94921252swags
swans84625012swans
swaps104819202swaps
swat77244442swat_
swath115920382swath
swaths125312642swaths
sways115518462sways
sweats94814612sweats
swots85518422swots
tats46858132_tats
teats55636812teats
twats86616602twats
ulans54921302ulans
vats76841742_vats
wats77555882_wats
whats117718992whats

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 Limit538003271.39038705.0
3Display Results3273270.0933516.1
 (SQL Overall)1786913271.576113382.6
 
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.