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

136 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
leaflets1124481(None) 
leafless11246571leafless
leaflet10199741leaflet_
eaglets84111662_eaglets
leadless9248792leadless
leafiest113410882leafiest
leafleted1342892leafleted
leafleter1242552leafleter
leafleters1342432leafleters
leakless12246982leakless
reflets103513152re_flets
aglets73915683__aglets
ballets93719513_ballets
beadles103414733beadle_s
beagles103212123beagle_s
beakless14297383beakless
beamless12327003beamless
beatless103311593beatless
beefless1335493beefless
befleas1236973be_fleas
befrets1237613be_frets
cablets114216343_cablets
callets93821703_callets
camlets114314623_camlets
caplets114914523_caplets
chalets122813473cha_lets
chaplets1556883chaplets
deafens11317253deaf_ens
deafest112911513deaf_est
deafness1236213deafness
dealers84118613dea_lers
defleas1147223de_fleas
deflects14336733de_flects
eagles73819163_eagle_s
eaglet73722583_eaglet_
earless74316073_earless
epaulets1043733epaulets
eyelets1057523_eyelets
fearless1137873fearless
flatlets1147373flatlets
gallets83517403_gallets
gearless937373gearless
haffets1636053_haffets
hamlets123211403_hamlets
haslets102510863_haslets
headless12289863headless
headsets1236053headsets
healers104319463hea_lers
heatless113011463heatless
kleagles1343143kleagle_s
labrets939363l_abrets
ladlers84613573l_adlers
ladles74619543l_adle_s
lancets93411163l_ancets
lappets11329123l_appets
lawless1037033l_awless
leachers133712813leachers
leaches123319343leache_s
leadens83610983lea_dens
leaders83819603lea_ders
leadiest93314983leadiest
leafages1244623leafages
leafed105713873leaf_e_d
leafier10329833leafie_r
leafiness1236483leafiness
leafleteer1351373leafleteer
leafleteers1461253leafleteers
leafleting1442893leafleting
leafletted1441973leafletted
leaflike1534713leaflike
leafs85721183leaf___s
leaguers935063leaguers
leagues837943league_s
leakers113415423lea_kers
leakiest123212793leakiest
lealty92910603lea_l_ty
leaners73718173lea_ners
leanest7415863lea_nest
leanness837373leanness
leapers93716663lea_pers
leariest83117843leariest
learners8398153learners
leasers74717843lea_sers
leases65428113lea_se_s
leashes103514403leashe_s
leasts64616413lea__sts
leathers114215083leathers
leavens10409303lea_vens
leavers103717783lea_vers
leaves94222383lea_ve_s
leaviest112910813leaviest
leets54927123le___ets
leftest10269463le_ftest
lefts86517813le_f__ts
legless838013le_gless
lensless835583lensless
levelers11259323levelers
leverets11297603leverets
loafers10349463loaf_ers
loamless10235213loamless
mallets93318493_mallets
mealless10288363mealless
measles92412753measle_s
meatless103410863meatless
palets85122313_pa_lets
pallets93919303_pallets
peakless14236683peakless
pearlers1039033pearlers
pellets94014783pe_llets
playlets1334903playlets
pleatless1134613pleatless
reales64934123rea_le_s
realest73322433rea_lest
reallots837993reallots
reflects13288873re_flects
reflet94024233re_flet_
reglets83512983re_glets
relets64025673re__lets
sallets73719653_sallets
samlets93813553_samlets
scarlets10178573scarlets
sealers74323553sea_lers
seamless10238723seamless
seatless83213003seatless
selfless1135013selfless
starlets81610083starlets
tablets94714383_tablets
tearless848713tearless
teazles16308923teazle_s
templets12226143templets
valets93715623_va_lets
varlets10411573_varlets
vealers103214293vea_lers
veinlets11144833veinlets
wallets103914833_wallets
zealots1636763zea_lots

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621367.61019206.6
3Display Results1361360.0602266.7
 (SQL Overall)1786911368.09322079.7
 
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.