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

377 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
landless9401117(None) 
glandless1134161glandless
handless123512061handless
landlers94312831landlers
sandless93212341sandless
aidless83612072_aidless
blandness1235972blandness
bondless1148812bondless
brandless1236122brandless
candlers114214102candlers
candles104422342candle_s
dandlers103912052dandlers
dandles94218532dandle_s
endless839832_endless
fangless1237662fangless
handlers124014142handlers
handles114020652handle_s
kindless13289242kindless
laceless10239852laceless
ladlers84613572la_dlers
ladles74619542la_dle_s
landers84026212land_ers
landler84113202landle_r
landmass1144422landmass
langleys1245102langleys
lankness12237042lankness
laundress1042812laundress
lawless1037032la_wless
leadless9248792leadless
lensless835582lensless
lidless8309272l_idless
lineless82711942lineless
lintless82710012lintless
lordless9277482lordless
maneless102812342maneless
manless93012932man_less
mindless11319442mindless
paneless102611762paneless
planless1036812plan_less
rankless12268232rankless
rindless92510192rindless
tankless12267822tankless
wardless12249302wardless
windless123310862windless
addles84216603_addle_s
address956103_address
ageless8310343_ageless
aimless93610813_aimless
airless73712043_airless
ancress978613_ancress
aneles64626293_anele_s
anglers84014823_anglers
angles74426703_angle_s
ankles104818383_ankle_s
anklets114310413_anklets
anoles64827433_anole_s
antlers74014743_antlers
armless9369943_armless
artless73712513_artless
ashless10318453_ashless
aweless1038723_aweless
awless939263_a_wless
awnless1035923_awnless
backless162910633backless
badness1039573ba_dness
baldness1137043baldness
banders104324563band_ers
bandies104124863bandie_s
bandiness122310243bandiness
bangles103617413bangle_s
barbless12318713barbless
barkless14318023barkless
barless94317003ba_rless
baseless1099563baseless
bathless13127383bathless
beardless1234913beardless
bedless1039703_bedless
bindles104016453bindle_s
bladeless1234303bladeless
blameless1334733blameless
blandest113811043bland_est
blankness1544673blankness
blindness1235343blindness
blondness1234963blondness
bloodless1234513bloodless
boneless10310213boneless
boundless1235183boundless
budless1038873_budless
bundlers11399183bundlers
bundles103515773bundle_s
candelas1139533candelas
candies104125613candie_s
candle94321483candle__
candled113815743candle_d
candler103516593candle_r
canoness1039393canoness
cantles94721413cantle_s
capless114312763ca_pless
careless102813633careless
carless95118493ca_rless
cashless1336773cashless
caudles103912813caudle_s
chadless1436403chadless
chandlers15387673chandlers
classless1143843classless
clawless1334123cla_wless
cloudless1243153cloudless
cordless11299963cordless
daddles104213803daddle_s
danders93921183dand_ers
dandies94121443dandie_s
dandiest103415033dandiest
dandle84218093dandle__
dandled103313543dandle_d
dandler94414273dandle_r
danglers103610593danglers
dangles93618423dangle_s
dankness13256693dankness
dateless9259963dateless
dauntless1033663dauntless
dawdlers13375673dawdlers
dawdles12379163dawdle_s
deedless10318253deedless
dindles93817243dindle_s
earless74316073ea_rless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fanciless1444603fanciless
fatless103212203fa_tless
finless102810783fin_less
flagless1235403fla_gless
flameless1435353flameless
flapless1335343fla_pless
flawless1434503fla_wless
fondlers12338023fondlers
fondles113512613fondle_s
fondness1237213fondness
foodless12338383foodless
fordless12289003fordless
gainless9117403gainless
ganders93521703gand_ers
gantlets9308903gantlets
gapless10349993ga_pless
garbless11388253garbless
gasless8319013ga_sless
gateless9279953gateless
gladness1036153gla_dness
glanders103811503gland_ers
glandes95413833gland_e_s
glandules1144253glandule_s
glassless1043873glassless
godless938403_godless
grandness1138303grandness
gunless8299633gun_less
hairless1157413hairless
haltless11308443haltless
handers114224333hand_ers
handiest123417783handiest
handiness132110933handiness
handle104219293handle__
handled124114533handle_d
handleless1473123handleless
handler113516163handle_r
handlist12311333handlist
handlists1347133handlists
handpress1544033handpress
handsels12317253handsels
handsets12258343handsets
hantles104117513hantle_s
hapless123311333ha_pless
hardness122411083hardness
harmless1337403harmless
hatless103813443ha_tless
headless12289863headless
heedless12278813heedless
hondles113614523hondle_s
hoodless12289733hoodless
inkless11348713_inkless
innless7288293_innless
jagless1537103ja_gless
janglers16319373janglers
jangles154015683jangle_s
jawless1745653ja_wless
kindlers13318483kindlers
kindles123614843kindle_s
kindness13236653kindness
kingless13288693kingless
kinless113310273kin_less
labelers10249413labelers
laciness102112553laciness
ladders94115173la_dders
laddies93715053laddie_s
ladens74516233la_d_ens
laders74927763la_d_ers
lades65141273la_d_e_s
ladies75124883la_die_s
ladle66320443la_dle__
ladled85013483la_dle_d
ladler74314933la_dle_r
lameness102612673lameness
lancelets1144833lancelets
lancers93616643lan_cers
lances84824103lan_ce_s
lancets93411163lan_cets
lanciers10308543lanciers
landaulets1142273landaulets
landaus8310343land_aus
landed84619243land_e_d
lander74028483land_e_r
landings103110073landings
landlady1343633landlady
landline9311443landline
landlines1039763landlines
landlopers1343673landlopers
landlord1045163landlord
landlords1144453landlords
landmen1038553landme_n
lands65426903land___s
landsleit1044203landsleit
landslips1284013landslips
lanes54946793lan__e_s
langley1147453langle_y
langrels9106173langrels
langues81211913langue_s
languets987243languets
lankest112714113lan_kest
lankiest122912503lankiest
lankiness1338053lankiness
lanners73618333lan_ners
lanolins8310533lanolins
larders83516943lard_ers
lardiest93813893lardiest
largess8408913la_rgess
lateness82614073lateness
lauders84012893laud_ers
launders9358743laund_ers
laxness1436043la_xness
laziness17239983laziness
leafless11246573leafless
leakless12246983leakless
leanness837373lean_ness
legless838013l_egless
lenders84419643lend_ers
lewdness1254173lewdness
lifeless11228143lifeless
limbless12246313limbless
limeless10249663limeless
lindens839413lind_ens
lindies8416583lindie_s
linerless936333linerless
lipless9259553l_ipless
listless8269263listless
loamless10235213loamless
loftless1135903loftless
loneness8512093loneness
longness938553longness
lossless835473lossless
loudness937013loudness
loveless1168573loveless
luckless14265893luckless
lunules738953lunule_s
madness10310073ma_dness
mailless10248583mailless
mandrels1137313mandrels
manglers113311903manglers
mangles104021463mangle_s
mantles94820703mantle_s
mantlets104611203mantlets
massless10277113massless
mastless102610023mastless
mateless102711293mateless
matless93014043ma_tless
nameless10248373nameless
napless93110283na_pless
nathless11127023nathless
needless9308333needless
oarless73913373oa_rless
paddlers12329153paddlers
paddles113515643paddle_s
padles95221123pa_dle_s
painless10108343painless
panders103423733pand_ers
pandies104224503pandie_s
pantdress1243363pantdress
passless10247223passless
pastless102411203pastless
pathless13138043pathless
placeless1335613placeless
planeness1138153planeness
plantlets1145013plantlets
playless1334863pla_yless
raddles93615703raddle_s
rainless8129703rainless
ranchless1444453ranchless
randies84225663randie_s
randiest93418773randiest
randiness102511443randiness
rankles113114543rankle_s
rankness12267943rankness
rayless10239003ra_yless
roadless937703roadless
rodless8310073_rodless
rundles83214713rundle_s
rundlets9307363rundlets
rungless956733rungless
runless72810423run_less
saddlers10289753saddlers
saddles95415743saddle_s
sadness8310613sa_dness
sailless82410373sailless
saltless8259343saltless
sanders84025943sand_ers
sandglass1143723sandglass
sandiest93218693sandiest
sandiness102111713sandiness
sandlots938293sandlots
saneness82313723saneness
sapless93313443sa_pless
sashless1136603sashless
seedless9319513seedless
sinless73014213sin_less
slanders94014013sland_ers
snapless10287463snapless
songless9218823songless
sonless72612613son_less
soundless1035533soundless
spanless10247363span_less
sundress936983sundress
sunless73013693sun_less
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
taintless935733taintless
tameless10259903tameless
tandems1037633tand_ems
tanglers92911973tanglers
tangles83920043tangle_s
tapeless10218643tapeless
taxless1436913ta_xless
tentless8229843tentless
thankless1633203thankless
tintless8239863tintless
toadless936313toadless
toneless8610393toneless
tuneless837913tuneless
undress838893_undress
unless62413073_un_less
ventless11249053ventless
waddlers13298333waddlers
waddles124314843waddle_s
wageless1237173wageless
wakeless1536473wakeless
wanders114221333wand_ers
wandle105316663wandle__
wanglers123310033wanglers
wangles113416933wangle_s
wanness102610683wan_ness
wardress12256163wardress
warless104015103wa_rless
wartless11279923wartless
wattless11268723wattless
waveless1437483waveless
wayless13308243wa_yless
weedless12287963weedless
weldless12285813weldless
windlass12266083windlass
windles113518493windle_s
wineless112711173wineless
wingless122910023wingless
winless103212283win_less
woodless12278453woodless
wordless12258843wordless
woundless1334033woundless
zanders173015793zand_ers
zaniness1738663zaniness
zoneless1737823zoneless

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 Filter1786911461620.420425454.8
2DLD Change Limit1461623777.03320782.3
3Display Results3773770.1562416.7
 (SQL Overall)1786913777.60923484.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.