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

361 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
ashless1031845(None) 
ashlers10319581ashlers
cashless1336771cashless
sashless1136601sashless
ageless8310342ageless
aidless83612072aidless
aimless93610812aimless
airless73712042airless
armless9369942armless
artless73712512artless
ashes86230612ash_e_s
ashiest10313952ashiest
ashiness1138962ashiness
ashlars10297062ashlars
ashler9459972ashle_r
assess65710462as_sess
aweless1038722aweless
awless939262a_wless
awnless1035922awnless
baseless1099562baseless
bathless13127382bathless
bushless1335812bushless
fishless1436412fishless
gasless8319012gas_less
massless10277112massless
mastless102610022mastless
nathless11127022nathless
passless10247222passless
pastless102411202pastless
pathless13138042pathless
rashness1138092rashness
sapless93313442sapless
shleps114710332_shleps
useless7188422useless
wishless1435992wishless
abbess10509773a_bbess
abeles84719393abele_s
ables75935543a_ble_s
ablest84721833a_blest
abscess1133903abscess
access1037683a_ccess
aches106132293ach_e_s
achiest12315183achiest
achiness1339703achiness
actress948533actress
aculeus937513aculeus
addles84216603addle_s
address956103address
aggress935593aggress
aglets73915683a_glets
aiglets84012913aiglets
aisles64721143aisle_s
alecs76620733a__lecs
alefs87319663a__lefs
ales47067103a__le_s
allees64521483a_llees
alleys95113303a_lleys
amblers115213563amblers
ambles105121863amble_s
amoles84122193amole_s
amplest11312333amplest
amulets939923amulets
ancress978613ancress
aneles64626293anele_s
anglers84014823anglers
angles74426703angle_s
ankles104818383ankle_s
anklets114310413anklets
anoles64827433anole_s
antlers74014743antlers
apheses12610703aph_eses
aphesis12610513aph_esis
apishness1445743apishness
apples104315763apple_s
applets115710063applets
aptness9268573aptness
archness1337513archness
argles75218483argle_s
arles56735743a_rle_s
armlets94610063armlets
asceses938623as_ceses
ascesis938373as_cesis
asepses946363asepses
ashcans1235183ashcans
ashed97829773ash_e_d
ashen87818673ash_e_n
ashier94714833ashie_r
ashlar9338193ashl_ar
ashlered1244623ashlered
ashmen1168173ashme_n
ashrams1236653ashrams
asides75118873aside_s
askers105915403as_kers
askeses1136463as_keses
askesis1136123as_kesis
asleep847283as_leep
aslosh966233as_losh
aspens85013353as_pens
aspers86220313as_pers
aspises9611643aspises
asses55629283as_se_s
assetless943573assetless
assets65617663as_sets
assholes1146743asshole_s
asters65631603as_ters
asylums1243633asylums
athlete1068083athlete
athletes1157883athletes
auklets11298573auklets
avulses1035433avulses
axles125219473a_xle_s
azaleas1636993azaleas
azoles154614613azole_s
backless162910633backless
barbless12318713barbless
barkless14318023barkless
barless94317003barless
baseness10910943baseness
bashers124820833bash_ers
bashes115631393bash_e_s
bashlyks2041973bashlyks
bassness1096743bassness
bedless1039703bedless
bibless11439173bibless
bless75917813__bless
bowless123310313bowless
braless92910563braless
brashness1436323brashness
brushless1444003brushless
budless1038873budless
capless114312763capless
careless102813633careless
carless95118493carless
cashes114729883cash_e_s
cashews15428603cash_ews
cashiers13318883cashiers
castles94917733castle_s
causeless1135193causeless
ceaseless1135733ceaseless
chess105016923_ch_ess
classless1143843classless
costless10310003costless
coxless1637743coxless
dasheens1244693dasheens
dashers115016863dash_ers
dashes106124983dash_e_s
dashiest12311113dashiest
dateless9259963dateless
deathless1335223deathless
dewless1137473dewless
dustless9328353dustless
earless74316073earless
easiness8313043easiness
echoless1345603echoless
eggless935663eggless
egoless836983egoless
endless839833endless
eyeless1058053eyeless
faceless13269173faceless
fadeless12258323fadeless
faithless1543903faithless
fameless13259203fameless
fangless1237663fangless
fashes124524023fash_e_s
fastness11238763fastness
fatless103212203fatless
feastless1235043feastless
feeless103511103feeless
finless102810783finless
fleshless1543993fleshless
flyless1335003flyless
fogless1138193fogless
furless103210143furless
fuseless11237233fuseless
gainless9117403gainless
gapless10349993gapless
garbless11388253garbless
gashes105725153gash_e_s
gashest114813413gash_est
gastness9278473gastness
gateless9279953gateless
glassless1043873glassless
godless938403godless
grassless1034303grassless
gumless10228273gumless
gunless8299633gunless
gustless9287683gustless
gutless82610713gutless
hairless1157413hairless
haltless11308443haltless
handless123512063handless
hapless123311333hapless
harmless1337403harmless
harshness1545963harshness
hasheesh1342593hasheesh
hashes125024803hash_e_s
haslets102510863has_lets
hassles103411693hassle_s
hatless103813443hatless
heathless1535593heathless
hipless12399923hipless
hitless103211193hitless
hueless1058823hueless
iceless9219963iceless
inkless11348713inkless
innless7288293innless
ireless72312243ireless
isleless834853isleless
isles54220563is_le_s
islets64513083is_lets
istles62814983istle_s
jagless1537103jagless
jawless1745653jawless
jobless16237563jobless
joyless17226513joyless
kashers143914023kash_ers
keyless1436163keyless
kinless113310273kinless
laceless10239853laceless
landless94011173landless
lashers104121833lash_ers
lashes94831003lash_e_s
lawless1037033lawless
legless838013legless
less45635103___less
lidless8309273lidless
lipless9259553lipless
listless8269263listless
lossless835473lossless
lushness1136233lushness
mailless10248583mailless
maneless102812343maneless
manless93012933manless
mashers124621053mash_ers
mashes115030003mash_e_s
mashies12318253mashie_s
matchless1644683matchless
mateless102711293mateless
matless93014043matless
nameless10248373nameless
napless93110283napless
natheless1244963natheless
netless739863netless
noseless839513noseless
oarless73913373oarless
orbless937493orbless
ostlers72911203ostlers
painless10108343painless
paneless102611763paneless
pashes115828393pash_e_s
pastness102510503pastness
pegless1038053pegless
pithless13117023pithless
poshness1356653poshness
rainless8129703rainless
ranchless1444453ranchless
rankless12268233rankless
rashers104020913rash_ers
rashes95330153rash_e_s
rashest103916873rash_est
rassles73513923rassle_s
rayless10239003rayless
restless82713163restless
ribless93410343ribless
rimless9369363rimless
riskless1235763riskless
rodless8310073rodless
runless72810423runless
rustless83510243rustless
ruthless1135413ruthless
sables85026693sable_s
sadness8310613sadness
sailers73822323sailers
sailless82410373sailless
saleps85014903_saleps
sales56055593_sale_s
sallets73719653sallets
saltless8259343saltless
samlets93813553samlets
sandless93212343sandless
sashes94728483sash_e_s
schleps1445483schleps
sexless1467243sexless
shales94731253_shale_s
sheas86331793_sh_eas
sheds96122703_sh_eds
sheens95116993_sheens
sheers94322403_sheers
sheesh1237813_sheesh
sheets93918503_sheets
shells94319523_shells
shes75734353_sh_e_s
shews115924713_sh_ews
shiels95418923_shiels
shiers94921753_shiers
shies86136553_shie_s
shiest95821523_shiest
shipless13277693_shipless
shitless11249243_shitless
shlep104914833_shle_p
shlepp13366193_shlepp
shlepps14394833_shlepps
shlubs11386733_shlubs
shoeless1137803_shoeless
shoers94518333_shoers
shoes85429663_shoe_s
shreds105613053_shreds
shrews129313923_shrews
shyers124712203_shyers
shyest125511833_shyest
shyness1344993_shyness
sighless1276553sighless
sinless73014213sinless
sleds64418853_s_leds
slews86220353_s_lews
soles55547923_sole_s
soleus64615613_soleus
sonless72612613sonless
stress66616673_stress
sumless92611123sumless
sunless73013693sunless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
tasteless935673tasteless
taxless1436913taxless
tieless72512563tieless
tipless92610063tipless
toeless72612393toeless
topless92511123topless
toyless10268713toyless
tugless837383tugless
tuskless1234213tuskless
unless62413073_unless
ushers94415533ush_ers
vastness11257293vastness
vestless11258843vestless
vowless13246603vowless
wageless1237173wageless
waistless1235093waistless
wakeless1536473wakeless
wardless12249303wardless
warless104015103warless
wartless11279923wartless
washers134517523wash_ers
washes124425493wash_e_s
washiest14310403washiest
washiness1537043washiness
wattless11268723wattless
waveless1437483waveless
wayless13308243wayless
webless1237003webless
wigless11359673wigless
winless103212283winless
witless103310983witless
yeastless1234053yeastless
zestless17247433zestless
zipless18276303zipless

Search took 10 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.920194229.3
2DLD Change Limit1340273618.26616214.3
3Display Results3613610.1432524.5
 (SQL Overall)1786913619.32919154.4
 
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.