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

273 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
lash7653965(None) 
ash67944601_ash
bash915240161bash
cash96636281cash
clash106219031clash
dash87031631dash
fash107232291fash
flash115716211flash
gash86833021gash
hash106936501hash
lakh114919951lakh
las37281471las_
lase46148511lase
lass47444541lass
last46260321last
lath76640381lath
leash85519211leash
lush75327691lush
mash96039401mash
pash95638131pash
plash104616561plash
rash76039931rash
sash77235301sash
slash84719681slash
wash106033811wash
aah616252962_aah
aahs716428562aahs
aas310975392aas_
abash106016512abash
ah513868792_a_h
ahs68644822_ahs
alas46358122alas_
als36663022als_
also46423442also
as211083072_as_
ashy107717352_ashy
ask77130702_ask
asp57235342_asp
ass37844062_ass
awash116613162awash
bach116131392bach
bah87755352ba_h
bas58681752bas_
base64847022base
bask105131422bask
bass66146782bass
bast66362412bast
bath95940082bath
blah98625062bla_h
blahs105616512blahs
blase75524232blase
blast76532572blast
blush105115312blush
bosh96328972bosh
brash106221562brash
bush96630712bush
calash11312432calash
caph116623292caph
casa65630862casa
case65848082case
cask105626432cask
cast67159902cast
clach124617822clach
clasp95517192clasp
class75525482class
clast76030582clast
cosh96127622cosh
crash109120012crash
dah78148982da_h
dahs88231812dahs
dashi95013112dashi
dashy125612382dashy
deash95617242deash
dish86328332dish
each95530582each
ease45042332ease
east46659102east
easy76224492easy
eath75735662eath
fas68262932fas_
fast77052312fast
fish106926272fish
flashy15498172flashy
flask125512422flask
flesh115013742flesh
flush115116072flush
gas48870252gas_
gasp76227332gasp
gast56052562gast
glass65518132glass
gnash9449832gnash
gosh86123422gosh
gush85424002gush
hah910655222ha_h
hahs108333362hahs
harsh116418052harsh
has67372652has_
hasp96627292hasp
hast76259482hast
hath105933912hath
hush105224112hush
josh145117612josh
kaph135815752kaph
kas77058582kas_
kasha124710722kasha
la219261632la__
lab58864782la_b
labs67145122labs
lac510155822la_c
lace66848472lace
lack105837682lack
lacs66942482lacs
lacy95829632lacy
lad48165702la_d
lade56345982lade
lads56549132lads
lady86527152lady
lag47862122la_g
lags56546222lags
laic65931562laic
laich105920712laich
laid56439142laid
laigh95515922laigh
lain46146282lain
lair45934152lair
laith85722102laith
lake85741602lake
lakhs125210342lakhs
laky116725822laky
lall45531312lall
lam57666712la_m
lama66635292lama
lamb86832142lamb
lame66849292lame
lamp86233822lamp
lams66552262lams
land56337312land
lane45153332lane
lang56637382lang
lank84734452lank
lap58565272la_p
laps66848872laps
lapse74917682lapse
lar37967532la_r
larch105919792larch
lard56742002lard
lari45839152lari
lark85733862lark
lars46956572lars
lased65132342lased
laser54633322laser
lases54944762lases
lashed105625212lashed
lasher94824532lasher
lashes94831002lashes
lassi56316852lassi
lasso55015682lasso
lasts57731262lasts
lat37593402la_t
latch104620462latch
late47560482late
lathe85626722lathe
lathi85417202lathi
laths86022402laths
lathy115215062lathy
lati46438272lati
latish92416172latish
lats45962702lats
latu47934182latu
laud56527722laud
laugh94414372laugh
lav66847342la_v
lava76725422lava
lavash12597372lavash
lave75642142lave
lavish124112982lavish
lavs76734152lavs
law68656642la_w
lawn75925632lawn
laws76441682laws
lax107651522la_x
lay68865352la_y
lays76043252lays
laze136235052laze
lazy166423072lazy
leach105422522leach
leas45954182leas_
lease55230262lease
least56134882least
lech96825442lech
les35663072les_
less45635102less
lest46956322lest
lich96230842lich
lis37162272lis_
lisp68926882lisp
list47055342list
loach105116362loach
loath84918602loath
loch95527132loch
lose45144582lose
loss45337962loss
lost47951492lost
loth76132132loth
lust47442602lust
lyase85512412lyase
lych126015762lych
lyse76320592lyse
mach116134482mach
marsh105320852marsh
mas58175822mas_
masa65034722masa
mashy136016502mashy
mask105227362mask
mass66044942mass
mast65959962mast
math95437452math
mesh96823002mesh
mosh95227602mosh
mush94929122mush
nah69847002na_h
nosh76223542nosh
oast47156322oast
oath76132152oath
pah88853592pa_h
pas58775742pas_
pase65346862pase
pasha105417182pasha
pass65239952pass
past65959012past
path99134912path
pish96127912pish
plashy14448872plashy
plasm94114632plasm
plush105614712plush
posh95427322posh
push95526622push
quash174512162quash
rah68052402ra_h
ras37575392ras_
rase46149982rase
rasp66029162rasp
rath76037662rath
resh76523452resh
rush76628182rush
sass45035622sass
sh56828522__sh
slosh84514482slosh
slush85316572slush
smash104814432smash
snash84815672snash
splash1168822splash
stash84916972stash
swash116316752swash
tach96132752tach
tas38477102tas_
task85326652task
tass45640572tass
tosh74826812tosh
trash86119762trash
tush74523902tush
unlash938792unlash
vas67755772vas_
vasa76522972vasa
vase75629652vase
vast75045122vast
was68767562was_
washy145911842washy
wasp95626852wasp
wast75655852wast
wish107228732wish
yah99046352ya_h
zas126946832zas_

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.283631417.0
2DLD Change Limit298722730.93631914.5
3Display Results2732730.0634333.3
 (SQL Overall)1786912731.282139384.6
 
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.