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

177 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
leaves9422238(None) 
cleaves124111621cleaves
deaves105319531deaves
eaves85231991_eaves
heaves124120301heaves
laves86039151l_aves
leases65428111leases
leave84723721leave_
leaved105719021leaved
leaven95013071leaven
leavens10409301leavens
leaver94321511leaver
leavers103717781leavers
loaves94813851loaves
reaves94127571reaves
sleaves103813201sleaves
weaves123616371weaves
agaves104611512agaves
aves76142602__aves
beaver114819252beaver
beavers124417322beavers
beeves114615042beeves
behaves15198522behaves
braves115524082braves
caves105639702_caves
ceases84427072ceases
claves115020062claves
cleave114212512cleave_
cleaved134010482cleaved
cleaver124110802cleaver
cleavers13398862cleavers
craves115825392craves
deave95022332deave_
deaved114916552deaved
deleaves1248062deleaves
delves104917082delves
eases56041612_eases
eave75733582_eave_
eaved95924502_eaved
elates65032362elates
elves85118742_elves
eves76230462_e_ves
faves115331422_faves
feases95422922feases
feazes184514172feazes
graves104624002graves
greaves113311442greaves
haves116034872_haves
heave114521812heave_
heaved134717862heaved
heaven123912602heaven
heavens13439302heavens
heaver124819672heaver
heavers133717192heavers
heavies132713872heavies
helves124316062helves
keeves133711982keeves
knaves13439522knaves
laces76141762l_aces
lades65141272l_ades
lakes95737652l_akes
lames75445542l_ames
lanes54946792l_anes
lares54852632l_ares
lases54944762l_ases
lavas85422222l_avas
lave75642142l_ave_
laved95028592l_aved
laver85031792l_aver
lavers94526362l_avers
lavs76734152l_av_s
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
lease55230262lease_
leased74722882leased
leaser65322672leaser
leasers74717842leasers
leashes103514402leashes
leasts64616412leasts
leavier10319992leavier
leaviest112910812leaviest
leavy115715772leav_y
leches115421312leches
ledges84917982ledges
lees45455882le__es
legates82917672legates
leges64427282le_ges
lenes54738522le_nes
lenses64620892lenses
leones64417722leones
leses54930812le_ses
lethes94818082lethes
leudes75314092leudes
levee84023812le_vee
levees93714522levees
level84116552le_vel
levels94113282le_vels
lever85125162le_ver
levers94621322le_vers
levies93919862levies
levis85818552le_vis
lexes127225262le_xes
lezzes14387832lezzes
lianes63819322lianes
lives86133192l_ives
loves85332012l_oves
lyases95211872lyases
naves87030382_naves
nerves94216192nerves
neves87021872ne_ves
oaves84925612_oaves
oleates7417832oleates
paves104833922_paves
peaces106324082peaces
peages94321842peages
peases85229472peases
peavey14398792peavey
peaveys15324062peaveys
peavies122213392peavies
peeves113814872peeves
pelves114514662pelves
pleases94515482pleases
raves85441972_raves
reales64934122reales
reave84528022reave_
reaved104523922reaved
reaver94524732reaver
reavers108320742reavers
reeves94721492reeves
reives95723042reives
repaves123513652repaves
saves85838632_saves
selves94119612selves
serves94423652serves
shaves125224932shaves
sheaves134412972sheaves
slaves95023022slaves
sleave94714152sleave_
sleaved113611132sleaved
sleazes162810332sleazes
sleeves103311342sleeves
soaves94218672soaves
staves94525192staves
teases65426272teases
traves94222742traves
verves124617882verves
waves115633922_waves
weave115218532weave_
weaved133913482weaved
weaver123916612weaver
weavers133714462weavers

Search took 4 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.1261418182.5
2DLD Change Limit825511772.84329036.6
3Display Results1771770.0632809.5
 (SQL Overall)1786911773.03258935.0
 
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.