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

231 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
heirless114605(None) 
hairless1157411hairless
heiress1036811heir_ess
airless73712042_airless
cheerless1495292cheerless
earless74316072_earless
fearless1137872fearless
gearless937372gearless
headless12289862headless
heartless1236392heartless
heatless113011462heatless
heedless12278812heedless
heelless11257652heelless
helmless1334272helmless
helpless1335062helpless
herbless1336662herbless
hipless12399922h_ipless
hitless103211192h_itless
peerless1037512peerless
reinless8139432reinless
tearless848712tearless
veinless11136262veinless
aidless83612073_aidless
aimless93610813_aimless
barless94317003_barless
beakless14297383beakless
beamless12327003beamless
beardless1234913beardless
beatless103311593beatless
bedless1039703be_dless
beefless1335493beefless
beltless10297713beltless
berryless1442293berryless
bibless11439173_bibless
birlers93813003_birlers
birles84920643_birle_s
brimless1235273brimless
carless95118493_carless
ceilers93912533cei_lers
checkless2044233checkless
cheekless1873883cheekless
chinless1337493chinless
coheiress1443353coheir_ess
dearness939973dearness
debtless1135653debtless
deedless10318253deedless
depress10239873depr_ess
dewless1137473de_wless
doorless936713doorless
dripless1135243dripless
eeriness8311873eeriness
eggless935663_eggless
egoless836983_egoless
egress73310433_egr_ess
endless839833_endless
exitless1534883exitless
eyeless1058053_eyeless
fairness1136563fairness
feckless17225783feckless
feeless103511103fe_eless
feetless1137383feetless
fernless1136063fernless
finless102810783_finless
fireless112810593_fireless
furless103210143_furless
gainless9117403gainless
hailers104017263hai_lers
hairiest11612473hairiest
hairiness1238013hairiness
hairnets1195633hairnets
haltless11308443haltless
handless123512063handless
hapless123311333h_apless
harmless1337403harmless
harness102413933h_arness
hatless103813443h_atless
healers104319463he_alers
hearers104319783hear_ers
hearkens15336693hearkens
hearses104414533hearse_s
heartens113010153heartens
heathless1535593heathless
hecklers17357123hecklers
heckles163711383heckle_s
heddles123311623heddle_s
heelers103815623he_elers
heifers1337933hei_fers
heiled104415613hei_le_d
heils85222193hei_l__s
heinies102514543heinie_s
heirdoms1444353heirdoms
heired103813043heir_e_d
heiresses1236963heiresses
heirloom1342733heirloom
heirlooms1442513heirlooms
heirs85618563heir___s
heisters113413133heisters
hellers103619833he_llers
henleys1334843he_nleys
henries102718283henrie_s
herders113914123he_rders
heres86245903he_r_e_s
heresy125011233he_r_esy
herls85226433he_rl__s
heroes94923823he_roe_s
herpes115517323he_rpe_s
herries104025073herrie_s
hideless12278713hideless
hillers103718733h_illers
hiltless11297123hiltless
hipness12277383h_ipness
hirees95117293h_ir_ees
hirers94518063h_ir_ers
hires86134343h_ir_e_s
hirples12149643h_irple_s
hirsels10128353h_irsels
hirsles101510073h_irsle_s
hiveless14227933hiveless
holeless1189363holeless
homeless131110143homeless
hoodless12289733hoodless
hoofless14258013hoofless
hookless151238363hookless
hoopless13279263hoopless
hopeless13118303hopeless
hornless1137363hornless
hueless1058823h_ueless
humorless1442963humorless
humpless15226333humpless
hurlers103714323h_urlers
hurleys13407333h_urleys
hurtless11307783hurtless
hymnless1632803hymnless
ireless72312243__ireless
keelless12236193keelless
kermess13396223ke_rmess
keyless1436163ke_yless
kinless113310273_kinless
kirmess13234313_kirmess
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013le_gless
lensless835583lensless
lidless8309273_lidless
lipless9259553_lipless
mailless10248583mailless
mealless10288363mealless
meatless103410863meatless
meritless1144593meritless
merles85322763me_rle_s
nearness838313nearness
neckless14236433neckless
needless9308333needless
netless739863ne_tless
newsless1134533newsless
oarless73913373_oarless
odorless934173odorless
painless10108343painless
peakless14236683peakless
pearlers1039033pearlers
peeress939503peer_ess
pegless1038053pe_gless
peltless10267373peltless
rainless8129703rainless
reckless14257973reckless
redress82511873redr_ess
regress82711453regr_ess
repress92712683repr_ess
restless82713163restless
ribless93410343_ribless
rimless9369363_rimless
sailless82410373sailless
scarless10189053scarless
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
seeress7311573seer_ess
selfless1135013selfless
sewerless1244303sewerless
sexless1467243se_xless
shearlegs1342493shearlegs
sheerlegs1343293sheerlegs
sheerness1236273sheerness
sheetless1235823sheetless
shipless13277693shipless
shirtless12266413shirtless
shitless11249243shitless
sinless73014213_sinless
skilless12246763skilless
skinless12216973skinless
skirtless13254423skirtless
slipless10246993slipless
slitless8268143slitless
soilless8279033soilless
spinless10238703spinless
stairless9185623stairless
starless81610843starless
tailless8239083tailless
tentless8229843tentless
termless1036233termless
textless15245793textless
thewless1433923the_wless
tieless72512563_tieless
tipless92610063_tipless
tireless82510263_tireless
twigless1293663twigless
twirlers11274303twirlers
veilers103911823vei_lers
veinlets11144833veinlets
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
viewless1434033viewless
warless104015103_warless
weariless1234763weariless
webless1237003we_bless
weedless12287963weedless
weirdest1244433weirdest
weirdness1343593weirdness
weldless12285813weldless
wheatless1534003wheatless
wheelless1543763wheelless
whelpless1742053whelpless
whirlers14286053whirlers
wigless11359673_wigless
winless103212283_winless
wireless11249633_wireless
witless103310983_witless
zestless17247433zestless
zipless18276303_zipless

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 Limit1461622316.61022112.3
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.12625075.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.