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

256 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
easy7622449(None) 
ease45042331ease
east46659101east
aas310975392aas_
aby810238062_aby
aery77231682aery
any68440482_any
as211083072_as_
ash67944602_ash
ashy107717352_ashy
ask77130702_ask
asp57235342_asp
ass37844062_ass
ay511773892_a_y
ays67050292_ays
baby116723672baby
bas58681752bas_
base64847022base
bash915240162bash
bask105131422bask
bass66146782bass
bassy1012917102bassy
bast66362412bast
bay89661642ba_y
bays97143912bays
beady114719922beady
beaky146118022beaky
beamy126218572beamy
beast76338642beast
busy94727172busy
cagy106321992cagy
caky136222442caky
casa65630862casa
case65848082case
cash96636282cash
cask105626432cask
casky144512682casky
cast67159902cast
cavy125920002cavy
cay87155982ca_y
cays95437672cays
cease75227652cease
cosy97232702cosy
creasy114612302creasy
daisy95915312daisy
dash87031632dash
dashy125612382dashy
davy116015522davy
day76254112da_y
days87637132days
deary95826842deary
deash95617242deash
each95530582each
ear36867882ea_r
earl45838142earl
early85324122early
earn46737552earn
ears46356592ears
eased65430402eased
easel54521112easel
eases56041612eases
easily9313022easily
easts57530322easts
eat36989052ea_t
eath75735662eath
eats47054872eats
eau37450942ea_u
eaux116618422eaux
eave75733582eave
eddy93912092eddy
edgy94713522edgy
eds46638922eds_
eely77725212eely
eery76129622eery
efs66829602efs_
eggy96611852eggy
elmy95616792elmy
els37645722els_
else45923082else
emmy116013242emmy
ems56435492ems_
ens37245922ens_
ensky1235092ensky
envy10411252envy
eras45441502eras_
erase54925492erase
ers36046282ers_
erst47436432erst
es29048222e_s_
espy969372espy
ess36030882e_ss
essay867622essay
etas46432272etas_
eyas76427432eyas_
eyass84410782eyass
eyry106315882eyry
fas68262932fas_
fash107232292fash
fast77052312fast
fay97454862fa_y
fays108535362fays
fease84824872fease
feast85932722feast
gaby107123192gaby
gamy105427532gamy
gapy106320912gapy
gas48870252gas_
gash86833022gash
gasp76227332gasp
gassy95514022gassy
gast56052562gast
gawsy12459092gawsy
gay76856492ga_y
gays87338022gays
greasy10419462greasy
has67372652has_
hash106936502hash
hasp96627292hasp
hast76259482hast
hasty115718762hasty
hay97358772ha_y
hays106138072hays
hazy1918119192hazy
heady125117262heady
heapy135914982heapy
heavy144814182heavy
jay136242672ja_y
jays146328342jays
kas77058582kas_
kay106745542ka_y
kays116032192kays
keas86337092keas_
lacy95829632lacy
lady86527152lady
laky116725822laky
las37281472las_
lase46148512lase
lash76539652lash
lass47444542lass
last46260322last
lay68865352la_y
lays76043252lays
lazy166423072lazy
leady95618602leady
leafy116316212leafy
leaky125217722leaky
leary85927382leary
leas45954182leas_
lease55230262lease
leash85519212leash
least56134882least
leavy115715772leavy
many95731842many
mas58175812mas_
masa65034712masa
mash96039392mash
mashy136016502mashy
mask105227352mask
mass66044932mass
massy104518962massy
mast65959952mast
may88757622ma_y
mays96940022mays
mazy186419692mazy
mealy104422182mealy
meany104620472meany
measly113610442measly
meaty107021312meaty
messy104913832messy
nary76931222nary
nasty85717282nasty
navy107518632navy
nay66952772na_y
nays75931592nays
newsy11489392newsy
nosy76322892nosy
oaky116419952oaky
oast47156322oast
pacy115328682pacy
palsy105417462palsy
paly95835532paly
pansy105717972pansy
pas58775742pas_
pase65346862pase
pash95638132pash
pass65239952pass
past65959012past
pasty105725052pasty
patsy105717202patsy
paty95234562paty
pay88461182pa_y
pays95940222pays
peaky145718152peaky
peas65755062peas_
pease75231112pease
peaty105725692peaty
peavy135014842peavy
posy96028422posy
queasy1855172queasy
racy95825682racy
ras37575392ras_
rase46149982rase
rash76039932rash
rasp66029162rasp
raspy106511702raspy
ray66361992ra_y
rays77642352rays
ready94821502ready
resay85320542resay
rosy76024872rosy
sagy85327082sagy
sash77235302sash
sass45035622sass
sassy85813812sassy
say67264762sa_y
says75942102says
seamy105921272seamy
seas45755272seas_
tansy84514932tansy
tas38477102tas_
task85326652task
tass45640572tass
tasty84820312tasty
teary85124052teary
teas45851492teas_
tease55428712tease
uneasy9278852uneasy
vary105226062vary
vas67755772vas_
vasa76522972vasa
vase75629652vase
vast75045122vast
vasty116215922vasty
vealy115817772vealy
wady115324992wady
waly105830902waly
wany106432352wany
wary106740012wary
was68767562was_
wash106033812wash
washy145911842washy
wasp95626852wasp
waspy135410992waspy
wast75655852wast
wavy136620472wavy
waxy175918202waxy
way96757662wa_y
ways107737952ways
weary115620612weary
yay96948712ya_y
yays105728912yays
yeas78638422yeas_
yeast85327942yeast
yeasty12438692yeasty
zany167316982zany
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.0632836365.1
2DLD Change Limit298722561.18625187.2
3Display Results2562560.0465565.2
 (SQL Overall)1786912561.295137985.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.