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

301 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
harmless133740(None) 
armless9369941_armless
charmless1633581charmless
aimless93610812_aimless
armlets94610062_armlets
artless73712512_artless
barbless12318712barbless
barkless14318022barkless
barless94317002bar_less
careless102813632careless
carless95118492car_less
chartless1435702chartless
earless74316072ear_less
formless13248082formless
garbless11388252garbless
gormless11235442gormless
hairless1157412hairless
haltless11308442haltless
hamlets123211402ha_mlets
handless123512062handless
hapless123311332ha_pless
hardness122411082hardness
harmers124116592harm_ers
harmlessly1842782harmlessly
harness102413932har_ness
harslets1137832harslets
hatless103813442ha_tless
heartless1236392heartless
helmless1334272helmless
herbless1336662herbless
hornless1137362hornless
hurtless11307782hurtless
normless10235922normless
oarless73913372oar_less
termless1036232termless
tramless1037502tramless
wardless12249302wardless
warless104015102war_less
warmness1337062warmness
wartless11279922wartless
ageless8310343_ageless
aidless83612073_aidless
airless73712043_airless
argles75218483_argle_s
arles56735743_ar_le_s
armers85520273_arm_ers
armets84918353_arm_ets
armies85123693_armie_s
armlet84118193_armle_t
armorless1143483_armorless
armrest9310163_armrest
armrests1055383_armrests
ashless10318453_ashless
aweless1038723_aweless
awless939263_a_wless
awnless1035923_awnless
backless162910633backless
bareness10912813bareness
barleys125011843bar_leys
barmiest125212783barmiest
baroness101210063baroness
baseless1099563baseless
bathless13127383bathless
beamless12327003beamless
beardless1234913beardless
braless92910563_braless
brimless1235273brimless
calmness1236643calmness
camlets114314623ca_mlets
capless114312763ca_pless
caress85720263car__ess
carles85435083car_le_s
carolers103314173carolers
cashless1336773cashless
chadless1436403cha_dless
chariness14310063chariness
charleys1695633char_leys
charmers154211333charm_ers
cordless11299963cordless
coreless103013833coreless
cureless10319703cureless
darkles124011933darkle_s
darkness13247343darkness
dartles84014133dartle_s
dateless9259963dateless
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
fangless1237663fangless
farles96025783far_le_s
farmers124315263farm_ers
farness102912203far_ness
fartleks1533963fartleks
fatless103212203fa_tless
fearless1137873fear_less
fernless1136063fernless
filmless1344553filmless
fireless112810593fireless
firmness1334743firmness
foamless13195843foamless
fordless12289003fordless
forkless15267433forkless
frameless1435533frameless
furless103210143fur_less
gainless9117403gainless
gapless10349993ga_pless
garblers113810283garblers
garbles104016923garble_s
garglers10418263garglers
gargles94214893gargle_s
gasless8319013ga_sless
gateless9279953gateless
gearless937373gear_less
gumless10228273_gumless
hacklers173710303hacklers
hackles162917063hackle_s
hagglers13326623hagglers
haggles123312483haggle_s
hailers104017263ha_ilers
hairiness1238013hairiness
haleness11312623haleness
halers94926913ha__lers
hales85449843ha__le_s
halest94823273ha__lest
halfness1435563halfness
hallels103310133ha_llels
hames106138703ha_m_e_s
hamlet113722793ha_mle_t
hammerless1742373hammerless
hammers144216063ha_mmers
hammiest152610003hammiest
hamminess1635713hamminess
hampers143616953ha_mpers
handlers124014143handlers
handles114020653handle_s
hantles104117513hantle_s
haoles94919803ha_ole_s
harass9313943har__ass
harasses11311033harasses
harborless1542663harborless
hardass1139753har_dass
hardens113815023har_dens
hardest113118413har_dest
hardies114923233hardie_s
hardiest123416333hardiest
hardiness132310353hardiness
hareems12428203har_eems
harelips1345213harelips
harems115513823har__ems
hares86255543har__e_s
harkens144112863har_kens
harlots103413293har_lots
harls85634503har_l__s
harmed125218833harm_e_d
harmer114719553harm_e_r
harmfulness1984283harmfulness
harmines132715143harmines
harmins123716723harm_ins
harms106829013harm___s
harpers124916203har_pers
harpies123818313harpie_s
harriers113712433harriers
harries103525493harrie_s
harshens1437603harshens
harshest14310193harshest
harshness1545963harshness
harslet10315653harsle_t
harvest132112753har_vest
harvests14246173har_vests
haslets102510863ha_slets
hassles103411693hassle_s
haulers104012443ha_ulers
haziness20248513haziness
headless12289863headless
heathless1535593heathless
heatless113011463heatless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helpless1335063helpless
hideless12278713hideless
hiltless11297123hiltless
hipless12399923h_ipless
hirples12149643hirple_s
hirsles101510073hirsle_s
hitless103211193h_itless
hiveless14227933hiveless
hoariness1238823hoariness
holeless1189363holeless
homeless131110133homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
horseless1237213horseless
hueless1058823h_ueless
humpless15226333humpless
hurdlers12337493hurdlers
hurdles113613373hurdle_s
hurlers103714323hur_lers
hurleys13407333hur_leys
hurtles103913753hurtle_s
hymnless1632803hymnless
ireless72312243_ireless
jagless1537103ja_gless
jawless1745653ja_wless
juryless1832983juryless
kermess13396223kerm_ess
kirmess13234313kirm_ess
laceless10239853laceless
landless94011173landless
largess8408913lar_gess
lawless1037033la_wless
loamless10235213loamless
lordless9277483lordless
mailless10248583mailless
maneless102812343maneless
manless93012933ma_nless
marblers12319233marblers
marbles114516653marble_s
marquess19204953marquess
martlets103310483martlets
massless10277113massless
mastless102610023mastless
mateless102711293mateless
matless93014043ma_tless
nameless10248373nameless
napless93110283na_pless
nathless11127023nathless
orbless937493_orbless
painless10108343painless
paneless102611763paneless
parflesh1643743parflesh
parles86334403par_le_s
parleys125212373par_leys
parolees104313983parolees
paroles95025883parole_s
parsleys1335083parsleys
partlets102811513partlets
passless10247223passless
pastless102411203pastless
pathless13138043pathless
portless10310643portless
rainless8129703rainless
rankless12268233rankless
rareness81112853rareness
rayless10239003ra_yless
rimless9369363_rimless
sailless82410373sailless
saltless8259343saltless
samlets93813553sa_mlets
sandless93212343sandless
sapless93313443sa_pless
sashless1136603sashless
scarless10189053scar_less
scumless1254993scumless
seamless10238723seamless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
sharpness1434933sharpness
shirtless12266413shirtless
shoreless1236633shoreless
starless81610843star_less
stemless1036653stemless
sumless92611123_sumless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
tartlets8289663tartlets
tartness82210133tartness
taxless1436913ta_xless
tearless848713tear_less
thankless1633203thankless
thawless1434083tha_wless
thornless1243633thornless
tireless82510263tireless
turfless1135533turfless
varlets10411573var_lets
verbless1336033verbless
wageless1237173wageless
wakeless1536473wakeless
warblers13319103warblers
warbles123215563warble_s
wardress12256163wardress
wariness11313213wariness
warmers124514293warm_ers
warmest123113033warm_est
warslers11328073warslers
warsles103413643warsle_s
wattless11268723wattless
waveless1437483waveless
wayless13308243wa_yless
weariless1234763weariless
wireless11249633wireless
wordless12258843wordless
workless15276803workless

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.423422437.4
2DLD Change Limit1461623017.14020470.9
3Display Results3013010.1232447.2
 (SQL Overall)1786913017.68623248.9
 
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.