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

279 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
mealless1028836(None) 
meatless103410861meatless
beakless14297382beakless
beamless12327002beamless
beatless103311592beatless
coalless1038192coalless
earless74316072_earless
fearless1137872fearless
gearless937372gearless
goalless935722goalless
headless12289862headless
heatless113011462heatless
heelless11257652heelless
idealless1042952idealless
keelless12236192keelless
leadless9248792leadless
leafless11246572leafless
leakless12246982leakless
mailless10248582mailless
mallees93315972m_allees
mallets93318492m_allets
malleus92911312m_alleus
manless93012932m_anless
matless93014042m_atless
mealies92821932mealie_s
mealiest102215972mealiest
mealiness11310062mealiness
meanness1037182meanness
measles92412752measle_s
peakless14236682peakless
realness8410442realness
seamless10238722seamless
seatless83213002seatless
tearless848712tearless
allees64521483__allees
alleys95113303__alleys
awless939263__awless
ballers94421013_ballers
ballets93719513_ballets
barless94317003_barless
beadles103414733beadle_s
beagles103212123beagle_s
beardless1234913beardless
bedless1039703be_dless
beefless1335493beefless
belles85325993be_lle_s
beltless10297713beltless
braless92910563bra_less
breadless1235943breadless
callees94117783_callees
callers94221963_callers
callets93821703_callets
capless114312763_capless
carless95118493_carless
ceaseless1135733ceaseless
chadless1436403chadless
clawless1334123clawless
coatless1039693coatless
dalles74222063_dalle_s
deadness1039233deadness
deafness1236213deafness
dealers84118613dea_lers
dearness939973dearness
deathless1335223deathless
debtless1135653debtless
decayless1542863decayless
deedless10318253deedless
dewless1137473de_wless
diallers957773diallers
dreamless1243513dreamless
eagles73819163_eagle_s
eaglets84111663_eaglets
eggless935663_eggless
egoless836983_egoless
endless839833_endless
eyeless1058053_eyeless
fallers103917993_fallers
fatless103212203_fatless
feastless1235043feastless
feckless17225783feckless
feeless103511103fe_eless
feetless1137383feetless
fellers104117543fe_llers
fellest10313753fe_llest
fellness1135913fellness
fernless1136063fernless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
foamless13195843foamless
galleass935053_galleass
gallets83517403_gallets
galleys11369713_galleys
gapless10349993_gapless
gasless8319013_gasless
hallels103310133_hallels
haltless11308443_haltless
hapless123311333_hapless
hatless103813443_hatless
healers104319463hea_lers
heartless1236393heartless
heathless1535593heathless
heedless12278813heedless
heirless1146053heirless
hellers103619833he_llers
helmless1334273helmless
helpless1335063helpless
herbless1336663herbless
idealess935653idea_less
jagless1537103_jagless
jawless1745653_jawless
keyless1436163ke_yless
lawless1037033_lawless
leaflets11244813leaflets
leanness837373leanness
legless838013le_gless
lensless835583lensless
loamless10235213loamless
macles107023223m_acle_s
madness10310073m_adness
maglevs1334693m_aglevs
mailers94420333m_ailers
mailes84329113m_aile_s
maleness10312313m_aleness
males75049793m_a_le_s
malled94626113m_alle_d
mallee84525593m_alle_e
mallei84414633m_alle_i
mallet84433053m_alle_t
mallows123714323m_allows
malls76233433m_all__s
malteds10377603m_alteds
maneless102812343maneless
maples104819423m_aple_s
massless10277113massless
mastless102610023mastless
mateless102711293mateless
maulers94213303m_aulers
mealie82519813mealie__
mealier93015903mealie_r
meals75933373mea_l__s
meanders1168833meanders
meaners94415243mea_ners
meanest9315703mea_nest
meanies93620743meanie_s
measle83513223measle__
measled10339303measle_d
measliest1147173measliest
meatiest102816793meatiest
meatiness11311183meatiness
meatuses1038203meatuses
medalled1246893medalle_d
medallist1246643medallist
medallists1344363medallists
meddlers12318203meddlers
meddles113213253meddle_s
medleys13115333me_dleys
meekness1434303meekness
meetness1036653meetness
melders103213913me_lders
melees83618083me__lees
melled95023023me_lle_d
mellows123812233me_llows
mells75031333me_ll__s
melters93918313me_lters
menseless1145203menseless
merciless1344473merciless
meritless1144593meritless
merles85322763me_rle_s
metalises11315073metalises
metalled1148983metalle_d
metallics1346133metallics
metallist1159673metallist
metallists1266713metallists
mettles94115023mettle_s
mewlers12288983me_wlers
milkless1434773milkless
millers93621343m_illers
milles84526563m_ille_s
millets94216843m_illets
mindless11319443mindless
moonless10278043moonless
moveless1367753moveless
mullens93611313m_ullens
mullers93217303m_ullers
mullets93614783m_ullets
mulleys12299203m_ulleys
napless93110283_napless
nearness838313nearness
neatness839153neatness
neckless14236433neckless
needless9308333needless
netless739863ne_tless
newsless1134533newsless
oarless73913373_oarless
ovalness1134673ovalness
pallets93919303_pallets
pearlers1039033pearlers
pedallers1244763pedallers
peerless1037513peerless
pegless1038053pe_gless
pellets94014783pe_llets
peltless10267373peltless
planless1036813planless
playless1334863playless
pleatless1134613pleatless
rayless10239003_rayless
reales64934123rea_le_s
realest73322433rea_lest
realises82420183realises
reallots837993reallots
realters83614043realters
reassess836513reassess
recallers1137103recallers
reckless14257973reckless
regalness1045473regalness
reinless8139433reinless
restless82713163restless
roadless937703roadless
sailless82410373sailless
sallets73719653_sallets
saltless8259343_saltless
sapless93313443_sapless
scaleless1135513scaleless
scarless10189053scarless
sealers74323553sea_lers
seedless9319513seedless
selfless1135013selfless
sellers73721313se_llers
selles64426983se_lle_s
sexless1467243se_xless
skilless12246763skilless
smallest1039403smallest
smallness1174513smallness
smellers10329763sme_llers
snapless10287463snapless
soapless10278073soapless
soilless8279033soilless
soulless8218763soulless
spallers102910733spallers
spanless10247363spanless
stalkless1333723stalkless
starless81610843starless
tailless8239083tailless
tallest7317093_tallest
tallness837103_tallness
taxless1436913_taxless
teazles16308923teazle_s
tellers73717593te_llers
tentless8229843tentless
termless1036233termless
textless15245793textless
thawless1434083thawless
toadless936313toadless
toolless836343toolless
trailless935963trailless
tramless1037503tramless
treadless1036003treadless
valleys13407483_valleys
vealers103214293vea_lers
vealiest112513203vealiest
veinless11136263veinless
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
wallets103914833_wallets
warless104015103_warless
wayless13308243_wayless
weakness1535353weakness
weariless1234763weariless
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
wellness1135793wellness
wheatless1534003wheatless
wheelless1543763wheelless
yeastless1234053yeastless
yellers103912953ye_llers
zestless17247433zestless

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.436409841.7
2DLD Change Limit1461622798.00018270.3
3Display Results2792790.1102536.4
 (SQL Overall)1786912798.54620909.3
 
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.