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

206 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
leases6542811(None) 
ceases84427071ceases
eases56041611_eases
feases95422921feases
lases54944761l_ases
lease55230261lease_
leased74722881leased
leaser65322671leaser
leasers74717841leasers
leashes103514401leashes
leasts64616411leasts
leaves94222381leaves
lenses64620891lenses
leses54930811le_ses
lyases95211871lyases
peases85229471peases
pleases94515481pleases
teases65426271teases
abases85720772abases
aliases7914492aliases
baases85218012baases
bases75644352_bases
beasts84519722beasts
beses75830722be_ses
biases84618432biases
blesses93812392blesses
cases75048382_cases
cease75227652cease_
ceased94920782ceased
censes83721802censes
cesses84221362cesses
chases115128232chases
cleanses10358142cleanses
cleaves124111622cleaves
crases85532312crases
creases94020962creases
deashes113313902deashes
deaves105319532deaves
debases103814132debases
degases93413102degases
ease45042332_ease_
eased65430402_eased
easel54521112_easel
easels65914552_easels
easies64126632_easies
easts57530322_easts
eaves85231992_eaves
elapses957662elapses
elates65032362elates
erases64425402erases
erses55826802_erses
eses45336102_e_ses
esses56422972_esses
eyases94513682eyases
fease84824872fease_
feased105718712feased
feasts95116092feasts
feazes184514172feazes
fesses94820252fesses
flenses1039472flenses
gases65633992_gases
greases84816712greases
hearses104414542hearses
heaves124120302heaves
ileuses738672ileuses
jesses135215952jesses
kvases13467102kvases
laces76141762l_aces
lades65141272l_ades
lakes95737652l_akes
lames75445542l_ames
lanes54946792l_anes
lapses85217692lapses
lares54852632l_ares
lase46148512l_ase_
lased65132342l_ased
laser54633322l_aser
lasers64925702l_asers
lashes94831002l_ashes
lass47444542l_as_s
lasses64827592lasses
lasts57731262l_asts
laves86039152l_aves
laxes125430092l_axes
lazes145129572l_azes
leaches123319342leaches
leaded84221542leaded
leaden74515222leaden
leadens83610982leadens
leader74824652leader
leaders83819602leaders
leads66028492lea_ds
leafed105713872leafed
leafs85721182lea_fs
leagues837942leagues
leaked114217702leaked
leaker104620072leaker
leakers113415422leakers
leaks95923912lea_ks
leaned73422542leaned
leaner64022192leaner
leaners73718172leaners
leanest7415862leanest
leans55536252lea_ns
leaped94317772leaped
leaper88118942leaper
leapers93716662leapers
leaps75522932lea_ps
learns65513742learns
lears55938732lea_rs
leas45954182lea__s
leash85519212leas_h
leashed113211162leashed
least56134882leas_t
leave84723722leave_
leaved105719022leaved
leaven95013072leaven
leavens10409302leavens
leaver94321512leaver
leavers103717782leavers
leches115421312leches
ledges84918012ledges
lees45455882le__es
legates82917682legates
leges64427292le_ges
lenes54738522le_nes
lense54523432lense_
lensed74015472lensed
leones64417722leones
less45635102le_s_s
lessee64116362lessee
lessees73510242lessees
lessen64212432lessen
lessens7409382lessens
lesser63514852lesser
lethes94818082lethes
leudes75314092leudes
levees93714522levees
levies93919862levies
lewises1039132lewises
lexes127225262le_xes
lezzes14387832lezzes
liaises7311052liaises
lianes63819322lianes
ligases82310712ligases
lipases9209482lipases
loaves94813852loaves
loesses7310032loesses
looses67328252looses
loses56742012l_oses
losses65925232losses
louses66230282louses
lyase85512412lyase_
lyses84518252l_yses
measles92412752measles
menses84222452menses
messes84924342messes
myases113711552myases
nesses64718322nesses
oases55330982_oases
oleates7417832oleates
pases75346502_pases
peaces106324082peaces
peages94321852peages
pease75231112pease_
peasen84815962peasen
peises84125042peises
perses85428062perses
phases114618402phases
please84315732please_
pleased103712072pleased
pleaser93912342pleaser
pleasers104010292pleasers
prases84429022prases
rases55447212_rases
reales64934122reales
reaves94127572reaves
releases8313342releases
reuses66025522reuses
seises64026712seises
senses63923942senses
sepses84515882sepses
sleaves103813202sleaves
sleazes162810332sleazes
stases64225562stases
tease55428712tease_
teased74721152teased
teasel63914982teasel
teasels74311312teasels
teaser65421522teaser
teasers75317242teasers
tenses64722552tenses
texases1437572texases
ukases10358062ukases
uneases73316262uneases
upases84112902upases
urases63723562urases
ureases74416722ureases
vases84626262_vases
verses94223762verses
weasel93410522weasel
weasels10468502weasels
weaves123616372weaves
yeasts96413052yeasts
yeses85119322ye_ses
yesses93615812yesses

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 Filter178691825510.330541487.9
2DLD Change Limit825512062.56332208.7
3Display Results2062060.0603433.3
 (SQL Overall)1786912062.95360511.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.