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

252 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
beamless1232700(None) 
beakless14297381beakless
beatless103311591beatless
seamless10238721seamless
barless94317002b_arless
beadles103414732beadle_s
beagles103212122beagle_s
beamiest123212762beamiest
beardless1234912beardless
bedless1039702be_dless
beefless1335492beefless
beltless10297712beltless
blameless1334732blameless
braless92910562bra_less
breadless1235942breadless
brimless1235272brimless
dreamless1243512dreamless
earless74316072_earless
fearless1137872fearless
foamless13195842foamless
gearless937372gearless
headless12289862headless
heatless113011462heatless
helmless1334272helmless
leadless9248792leadless
leafless11246572leafless
leakless12246982leakless
loamless10235212loamless
mealless10288362mealless
meatless103410862meatless
peakless14236682peakless
seatless83213002seatless
tearless848712tearless
termless1036232termless
tramless1037502tramless
aimless93610813_aimless
armless9369943_armless
awless939263__awless
backless162910633backless
badness1039573b_adness
bailees93914383b_ailees
bailers94221353b_ailers
baileys12388933b_aileys
balers85626933b_a_lers
bales76250083b_a_le_s
ballers94421013b_allers
ballets93719513b_allets
barbless12318713barbless
barkless14318023barkless
barleys125011843b_arleys
baseless1099563baseless
bathless13127383bathless
bawlers124412733b_awlers
beaches144120653beache_s
beaders104120183bea_ders
beadiest113815533beadiest
beadiness12249233beadiness
beadle93314683beadle__
beagle93612593beagle__
beakers134216873bea_kers
beakiest143313463beakiest
beamed115720733beam_e_d
beamier113411943beamie_r
beamish14259293beam_ish
beamlike16115843beamlike
beams95328173beam___s
beanies93821093beanie_s
bearers94619593bea_rers
beaters94925043bea_ters
beavers124417323bea_vers
beetlers1037403beetlers
beetles9312083beetle_s
befleas1236973be_fleas
belles85325993be_lle_s
bemuses1139293be_muses
benames112814603benam_e_s
benchless1644153benchless
bermes106023003berm_e_s
berryless1442293berryless
besmiles1237393besmile_s
bevelers13389463bevelers
bewailers1434233bewailers
biasness1035813biasness
bibless11439173b_ibless
bladeless1234303bladeless
blamers115314213blam_ers
blames105121863blam_e_s
bleakness1543593bleakness
bless75917813b___less
bloomless1342963bloomless
blotless10347153blotless
bodiless1135913bodiless
boltless10338283boltless
bondless1148813bondless
boneless10310213boneless
boomlets12246673boomlets
boonless10328353boonless
bootless103410983bootless
bowless123310313b_owless
bractless1335543bractless
brainless1136403brainless
brakeless1544993brakeless
brambles14308973bramble_s
brandless1236123brandless
brawlers13408643brawlers
breathless1543533breathless
browless1346653browless
budless1038873b_udless
bushless1335813bushless
camlets114314623_camlets
capless114312763_capless
carless95118493_carless
ceaseless1135733ceaseless
chadless1436403chadless
charmless1633583charmless
clawless1334123clawless
coalless1038193coalless
coatless1039693coatless
deadness1039233deadness
deafness1236213deafness
dealers84118613dea_lers
dearness939973dearness
deathless1335223deathless
debtless1135653debtless
decayless1542863decayless
deedless10318253deedless
dewless1137473de_wless
eagles73819163_eagle_s
eaglets84111663_eaglets
eggless935663_eggless
egoless836983_egoless
endless839833_endless
eyeless1058053_eyeless
fameless13259203_fameless
fatless103212203_fatless
feastless1235043feastless
feckless17225783feckless
feeless103511103fe_eless
feetless1137383feetless
females12310663female_s
fernless1136063fernless
filmless1344553filmless
flagless1235403flagless
flameless1435353flameless
flapless1335343flapless
flawless1434503flawless
formless13248083formless
frameless1435533frameless
gapless10349993_gapless
gasless8319013_gasless
goalless935723goalless
gormless11235443gormless
gumless10228273_gumless
hamlets123211403_hamlets
hapless123311333_hapless
harmless1337403harmless
hatless103813443_hatless
healers104319463hea_lers
heartless1236393heartless
heathless1535593heathless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helpless1335063helpless
herbless1336663herbless
idealess935653idea_less
idealless1042953idealless
jagless1537103_jagless
jawless1745653_jawless
keelless12236193keelless
kermess13396223kerm_ess
keyless1436163ke_yless
lawless1037033_lawless
leaflets11244813leaflets
leanness837373leanness
legless838013le_gless
lensless835583lensless
manless93012933_manless
matless93014043_matless
meanness1037183meanness
measles92412753measle_s
nameless10248373_nameless
napless93110283_napless
nearness838313nearness
neatness839153neatness
neckless14236433neckless
needless9308333needless
netless739863ne_tless
newsless1134533newsless
normless10235923normless
oarless73913373_oarless
pearlers1039033pearlers
peerless1037513peerless
pegless1038053pe_gless
peltless10267373peltless
planless1036813planless
playless1334863playless
pleatless1134613pleatless
rayless10239003_rayless
reales64934123rea_le_s
realest73322433rea_lest
realness8410443realness
reamers94221083ream_ers
reassess836513reassess
reckless14257973reckless
reinless8139433reinless
restless82713163restless
rimless9369363_rimless
roadless937703roadless
samlets93813553_samlets
sapless93313443_sapless
scarless10189053scarless
scumless1254993scumless
sealers74323553sea_lers
seamers94719433seam_ers
seamiest102715423seamiest
seaminess11310473seaminess
seamlessly1543203seamlessly
seedless9319513seedless
selfless1135013selfless
sexless1467243se_xless
shameless1435923shameless
snapless10287463snapless
soapless10278073soapless
spanless10247363spanless
stampless1334543stampless
starless81610843starless
stemless1036653stemless
sumless92611123_sumless
tameless10259903_tameless
taxless1436913_taxless
teazles16308923teazle_s
tentless8229843tentless
textless15245793textless
thawless1434083thawless
toadless936313toadless
treadless1036003treadless
vealers103214293vea_lers
veinless11136263veinless
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
warless104015103_warless
wayless13308243_wayless
weakness1535353weakness
weariless1234763weariless
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
wheatless1534003wheatless
yeastless1234053yeastless
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.423422437.4
2DLD Change Limit1461622527.72018932.9
3Display Results2522520.0932709.7
 (SQL Overall)1786912528.23621696.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.