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

115 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
easel5452111(None) 
ease45042331ease_
eased65430401eased
easels65914551easels
eases56041611eases
teasel63914981teasel
weasel93410521weasel
asea46327182_asea
axel115222072_axel
babel95821692babel
bagel85116792bagel
basal75722282basal
base64847022base_
based85331582based
basely114412312basely
baser74828922baser
bases75644352bases
basil75122272basil
camel96822802camel
case65848082case_
cased86032412cased
cases75048382cases
cease75227652cease_
ceased94920782ceased
ceases84427072ceases
damsel9148032damsel
deasil71110982deasil
eager65526972eager
eagle64219482eagle
eared65139502eared
earl45838142ea_rl
easeful1037292easeful
easeled8159862easeled
easier64218462easier
easies64126632easies
easily9313022easily
east46659102eas_t
easter65027982easter
easts57530322easts
easy76224492eas_y
eaten55323052eaten
eater54639842eater
eave75733582eave_
eaved95924502eaved
eaves85231992eaves
eel37946842e__el
else45923082else_
enamel81210112enamel
erase54925492erase_
erased74816752erased
eraser64216332eraser
erases64425402erases
erses55826802erses
eses45336102e_ses
esses56422972esses
excel1437742excel
expel1448232expel
eyases94513682eyases
fease84824872fease_
feased105718712feased
feases95422922feases
fusel85218492fusel
gases65633992gases
gavel95815182gavel
hansel95214372hansel
hassel95614212hassel
hazel176414812hazel
hosel86024812hosel
label75019382label
lapel73716682lapel
lase46148512lase_
lased65132342lased
laser54633322laser
lases54944762lases
lease55230262lease_
leased74722882leased
leaser65322672leaser
leases65428112leases
losel54419422losel
maser75029972maser
measle83513222measle
nasal56217592nasal
navel87016572navel
oases55330982oases
ousel55222402ousel
panel76023622panel
pase65346862pase_
paseo77022512paseo
pases75346502pases
passel85117002passel
pastel85918712pastel
pease75231112pease_
peasen84815962peasen
peases85229472peases
rase46149982rase_
rased65033932rased
raser55633412raser
rases55447212rases
ratel54224882ratel
ravel84621512ravel
sel38253322__sel
tael46030712ta_el
tassel66014772tassel
tease55428712tease_
teased74721152teased
teasels74311312teasels
teaser65421522teaser
teases65426272teases
teazel15368542teazel
vasal85516292vasal
vase75629652vase_
vases84626262vases
vessel937952vessel
weasels10468502weasels
weasely13317852weasely

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.296603685.8
2DLD Change Limit538001151.58034050.6
3Display Results1151150.0462500.0
 (SQL Overall)1786911151.92292971.4
 
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.