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

168 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
least5613488(None) 
beast76338641beast
east46659101_east
feast85932721feast
last46260321l_ast
leant56737781leant
leapt75027471leapt
leas45954181leas_
lease55230261lease
leash85519211leash
leasts64616411leasts
lest46956321le_st
yeast85327941yeast
avast85519362avast
bast66362412_bast
beasts84519722beasts
beat66168302bea_t
beats76042242beats
beaut75135212beaut
best66355322be_st
blast76532572blast
bleat75737002blea_t
bleats85518612bleats
blest76431722ble_st
boast75935702boast
breast8319632breast
cast67159902_cast
cease75227652cease
clast76030582clast
cleat76335062clea_t
cleats84919312cleats
coast75236272coast
dealt65234282dealt
deash95617242deash
deist64633592deist
demast9517062demast
ease45042332_ease
easts57530322_easts
easy76224492_easy
eat36989052_ea_t
eats47054872_eats
erst47436432_erst
fast77052312_fast
fease84824872fease
feasts95116092feasts
feat76458222fea_t
feats86432752feats
feist86230072feist
fest74949442fe_st
fleas86423662fleas_
gast56052562_gast
geest64829622geest
gest56149132ge_st
ghast95621222ghast
hast76259482_hast
heart85440742heart
heat77061422hea_t
heats85838402heats
heist87030912heist
hest75950772he_st
jest116738502je_st
keas86337092keas_
las37281472l_as_
lase46148512l_ase
lash76539652l_ash
lass47444542l_ass
lasts57731262l_asts
lat37593402l_a_t
lats45962702l_ats
lea37660182lea__
leach105422522leach
lead56038852lea_d
leads66028492leads
leady95618602leady
leaf76441032lea_f
leafs85721182leafs
leafy116316212leafy
leak86233712lea_k
leaks95923912leaks
leaky125217722leaky
leal46043272lea_l
lealty92910602lealty
lean46345242lea_n
leanest7415862leanest
leans55536252leans
leap66032682lea_p
leaps75522932leaps
lear47045952lea_r
learn55322662learn
learnt64019252learnt
lears55938732lears
leary85927382leary
leased74722882leased
leaser65322672leaser
leases65428112leases
leave84723722leave
leavy115715772leavy
lees45455882lees_
leet45957902le_et
leets54927122leets
left76340482le_ft
lefts86517812lefts
legist71315252legist
legit61323502legit
legs56133692legs_
leis45739602leis_
leks85427602leks_
lens46146492lens_
lense54523432lense
lent46360532le_nt
lept66440882le_pt
les35663072le_s_
less45635102le_ss
let36481472le__t
lets47147942lets_
levant9314492levant
leys76430182leys_
list47055342l_ist
lost47951492l_ost
lust47442602l_ust
lyart85121882lyart
lyase85512412lyase
mast65959962_mast
meant76537212meant
meat66359602mea_t
meats75034052meats
neat46356782nea_t
neats55931902neats
neist54628442neist
nest45548732ne_st
oast47156322_oast
past65959012_past
peart76440752peart
peas65755062peas_
pease75231112pease
peat65967932pea_t
peats76140192peats
pest65555292pe_st
pleas75627032pleas_
please84315732please
pleat74734472plea_t
pleats85218592pleats
react74634332react
recast83422772recast
reest54938092reest
repast83520632repast
resat55139682resat
rest46459842re_st
roast56230142roast
seas45755272seas_
seat47575562sea_t
seats54844342seats
teas45851492teas_
tease55428712tease
teat45963632tea_t
teats55636812teats
test48651622te_st
toast55831012toast
vast75045122_vast
verst84429372verst
vest75743602ve_st
wast75655852_wast
weest85026772weest
west75748082we_st
yeas78638422yeas_
yeasts96413052yeasts
yeasty12438692yeasty
zest136035702ze_st

Search took 3 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.296603685.8
2DLD Change Limit538001681.65632487.9
3Display Results1681680.0305600.0
 (SQL Overall)1786911681.98290156.9
 
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.