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

151 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
heartless123639(None) 
heatless113011461hea_tless
artless73712512__artless
beardless1234912beardless
beatless103311592bea_tless
chartless1435702chartless
earless74316072_ear_less
fearless1137872fear_less
feastless1235042feastless
gearless937372gear_less
haltless11308442h_altless
harmless1337402h_armless
hatless103813442h_a_tless
headless12289862hea_dless
heartens113010152heart_ens
hearties11315412heartie_s
heartiest12311102heartiest
heartiness1338032heartiness
heartlessly1742732heartlessly
heathless1535592heathless
heirless1146052heir_less
herbless1336662he_rbless
hurtless11307782h_urtless
meatless103410862mea_tless
peartness1137772peartness
seatless83213002sea_tless
tearless848712tear_less
wartless11279922_wartless
weariless1234762weariless
wheatless1534002whea_tless
yeastless1234052yeastless
apartness1146053apartness
armless9369943__armless
barbless12318713_barbless
barkless14318023_barkless
barless94317003_bar_less
beakless14297383bea_kless
beamless12327003bea_mless
beltless10297713be_ltless
berryless1442293berryless
bractless1335543bractless
careless102813633_careless
carless95118493_car_less
ceaseless1135733ceaseless
charmless1633583charmless
cheerless1495293cheer_less
coatless1039693coa_tless
dartles84014133_dartle_s
dearness939973dear_ness
deathless1335223deathless
debtless1135653de_btless
exitless1534883_exitless
fartleks1533963_fartleks
fatless103212203_fa_tless
feetless1137383fe_etless
fernless1136063fe_rnless
garbless11388253_garbless
hairless1157413h_airless
handless123512063h_andless
hantles104117513h_antle_s
hapless123311333h_a_pless
hardness122411083h_ardness
harness102413933h_ar_ness
harslets1137833h_arslets
headdress1443753headdress
headiness132510363headiness
healers104319463hea__lers
hearers104319783hear__ers
hearkens15336693hear_kens
hearses104414533hear_se_s
heartbeat1444633heartbeat
heartbeats1552783heartbeats
hearted113314023heart_e_d
hearten102411753heart_e_n
hearteners1346213hearteners
heartfelt1543263heartfelt
hearths135311073heart__hs
heartier1139093heartie_r
heartland1343653heartland
heartlands1462953heartlands
hearts96218943heart___s
heartsease1352313heartsease
heartseases1452593heartseases
heaters104225223hea_t_ers
heathens143210153hea_thens
heathers143914733hea_thers
heaviness15207063heaviness
heedless12278813he_edless
heelless11257653he_elless
heiress1036813heir__ess
helmless1334273he_lmless
helpless1335063he_lpless
hertzes1938303he_rtze_s
hiltless11297123h_iltless
hitless103211193h__itless
hoariness1238823hoariness
hornless1137363h_ornless
hurtles103913753h_urtle_s
leadless9248793lea_dless
leafless11246573lea_fless
leakless12246983lea_kless
martlets103310483_martlets
mastless102610023_mastless
matless93014043_ma_tless
mealless10288363mea_lless
meritless1144593meritless
nearness838313near_ness
neatness839153nea_tness
netless739863ne__tless
oarless73913373_oar_less
partlets102811513_partlets
pastless102411203_pastless
peakless14236683pea_kless
pearlers1039033pear_lers
peartest10311303peart_est
peerless1037513peer_less
peltless10267373pe_ltless
pertness10310093pe_rtness
pleatless1134613plea_tless
portless10310643_portless
regardless1252893regardless
restless82713163re_stless
saltless8259343_saltless
scarless10189053scar_less
seamless10238723sea_mless
searchless1543373searchless
shearlegs1342493shear_legs
sheetless1235823she_etless
shirtless12266413shirtless
skirtless13254423skirtless
smartness1136143smartness
starless81610843star_less
startlers9236743startlers
startles82111963startle_s
swartness1236113swartness
tactless10288463_tactless
tartlets8289663_tartlets
tartness82210133_tartness
teariness9310633teariness
tenantless1043053tenantless
tentless8229843te_ntless
termless1036233te_rmless
textless15245793te_xtless
ventless11249053ve_ntless
verbless1336033ve_rbless
vestless11258843ve_stless
wardless12249303_wardless
warless104015103_war_less
wattless11268723_wattless
weariness1238843weariness
zestless17247433ze_stless

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411517.53019739.8
3Display Results1511510.0632396.8
 (SQL Overall)1786911518.01622291.8
 
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.