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 “leaflet” with Change Limit: [1] [2] [3]

(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
leaflet1019974(None) 
leaflets11244811leaflets
eaglet73722582_eaglet
leafed105713872leaf_ed
leafier10329832leafier
leafiest113410892leafiest
leafless11246572leafless
leafleted1342892leafleted
leafleter1242552leafleter
reflet94024232re_flet
aglet65534143__aglet
ballet84733973_ballet
beadle93314683beadle_
beadles103414733beadles
beagle93612593beagle_
beagles103212123beagles
beflea1147123be_flea
befret11315963be_fret
cablet104429463_cablet
callet84536763_callet
camlet104426583_camlet
caplet104226813_caplet
chalet113825993cha_let
chaplet14512253chaplet
deafen10389673deaf_en
deafer104114813deaf_er
deafest112911513deafest
deafly13389123deafl_y
dealer74122143dea_ler
dealt65234283dea_l_t
deflea1037443de_flea
deflect13399973de_flect
eagle64219483_eagle_
eagled82914043_eagled
eagles73819163_eagles
eaglets84111663_eaglets
epaulet939513epaulet
eyelet9514533_eyelet
flatlet10312253flatlet
gallet73630853_gallet
haffet15311703_haffet
hamlet113722793_hamlet
haslet93222713_haslet
headset11312603headset
healed105121443hea_led
healer94221803hea_ler
kleagle1242933kleagle_
kleagles1343143kleagles
labret8320223l_abret
ladle66320443l_adle_
ladled85013483l_adled
ladler74314933l_adler
ladles74619543l_adles
lalled74218753l_alled
lancet84223573l_ancet
lappet103817733l_appet
leached133715043leached
leacher124014843leacher
leaches123319343leaches
leaded84221543lea_ded
leaden74515223lea_den
leader74824653lea_der
leadier83212723leadier
leadiest93314993leadiest
leadless9248793leadless
leadmen10277903leadmen
leaf76441033leaf___
leafage1194573leafage
leafages1244623leafages
leafing113313583leafing
leafleteer1351373leafleteer
leafleters1342433leafleters
leafleting1442893leafleting
leafletted1441973leafletted
leaflike1534713leaflike
leafs85721183leaf__s
leafy116316213leaf__y
league758743league_
leagued935463leagued
leaguer835793leaguer
leagues837943leagues
leaked114217703lea_ked
leaker104620073lea_ker
leakier114010993leakier
leakiest123212803leakiest
leakless12246983leakless
leal46043273lea_l__
leally94012613lea_lly
lealty92910603lea_lty
leaned73422543lea_ned
leaner64022193lea_ner
leanest7415863leanest
leanly93811503leanl_y
leant56737783lea__nt
leaped94317773lea_ped
leaper88118943lea_per
leapt75027473lea__pt
learier73415663learier
leariest83117853leariest
learned8329303learned
learner7319383learner
learnt64019253lea_rnt
lease55230263lea_se_
leased74722883lea_sed
leaser65322673lea_ser
leases65428113lea_ses
leashed113211163leashed
leashes103514403leashes
least56134883lea__st
leather103815783leather
leave84723723lea_ve_
leaved105719023lea_ved
leaven95013073lea_ven
leaver94321513lea_ver
leaves94222383lea_ves
leavier10319993leavier
leaviest112910823leaviest
leet45957903le___et
left76340483le_f__t
lefter93613433le_fter
leftest10269463le_ftest
leveled114010383leveled
leveler10399903leveler
leveret103014003leveret
liable81415813liable_
loafed104011153loaf_ed
loafer93610943loaf_er
mallet84433053_mallet
measle83513223measle_
measled10339303measled
measles92412753measles
palet74650803_pa_let
pallet84232653_pallet
pealed95322813pea_led
pearled10411553pearled
pearler9310373pearler
pellet83326553pe_llet
playlet1239523playlet
realer63528593rea_ler
reales64934123rea_les
realest73322433rea_lest
reallot7312133reallot
refelt94521423re_felt
reflect123913713re_flect
reflets103513153re_flets
reflew12389453re_flew
reflex16359513re_flex
reglet73724233re_glet
relet54749823re__let
sallet63734543_sallet
samlet84126563_samlet
scarlet91516943scarlet
sealed74328363sea_led
sealer63928963sea_ler
starlet71620123starlet
tablet84227643_tablet
teazle15329553teazle_
teazled17326833teazled
teazles16308923teazles
templet112712003templet
valet84337873_va_let
varlet9423503_varlet
vealed103916323vea_led
vealer94016543vea_ler
veinlet101310573veinlet
wallet93327093_wallet
webfeet1544593webfeet
zealot15313473zea_lot

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271686.72019944.5
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.18924856.2
 
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.