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

118 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
heartiness133803(None) 
artiness81615402__artiness
earliness939692_earliness
earthiness1377242_earthiness
hardiness132310362h_ardiness
hastiness122410882h_astiness
headiness132510362hea_diness
healthiness1744092healthiness
hearteners1346212hearteners
hearties11315412hearti_e_s
heartiest12311102hearti_est
heartinesses1548002heartinesses
heartless1236392heart_less
heaviness15207062hea_viness
heftiness1536312he_ftiness
hoariness1238822hoar_iness
meatiness11311182mea_tiness
peartness1137772peart_ness
tartiness92112052_tartiness
teariness9310632tear_iness
weariness1238842wear_iness
yeastiness1344882yeastiness
apartness1146053apart_ness
artsiness937653__artsiness
battiness11239843_battiness
beadiness12249233bea_diness
beastliness1343333beastliness
beeriness1137863beer_iness
bleariness1246053blear_iness
brattiness1255843brattiness
cattiness112310633_cattiness
chariness14310063char_iness
chattiness1565123chattiness
cheeriness1545533cheer_iness
craftiness1545753craftiness
deadliness12115893deadliness
dearness939973dear__ness
dirtiness1039473_dirtiness
draftiness1444863draftiness
dreariness1146283drear_iness
earthliness14144143_earthliness
earwitness1342623_earwitness
easiness8313043_ea_siness
eeriness8311873_eer_iness
emptiness1335373_emptiness
fattiness12239373_fattiness
feistiness1345073feistiness
germiness1257693ge_rminess
glariness1038553glar_iness
hairiness1238013h_airiness
hamminess1635713h_amminess
handiness132110933h_andiness
happiness1636003h_appiness
hardness122411083h_ar_dness
harmines132715143h_armine_s
harness102413933h_ar__ness
harshness1545963h_arshness
haziness20248513h_a_ziness
headliners14144333headliners
headlines13119013headline_s
hearings123611853hear_in_gs
hearkeners1743983hearkeners
heartened1347063heartene_d
heartener1256763heartene_r
heartens113010153heart__ens
heartier1139093hearti_e_r
hearting12513123heartin__g
heartsickness2261163heartsickness
heathless1535593hea_thless
heatless113011463hea_t_less
hematines141312203hematine_s
heroines112916573he_roine_s
hoarseness1345313hoarseness
horniness12309143h_orniness
horsiness12259473h_orsiness
jerkiness20175643je_rkiness
jettiness1675693je_ttiness
larkiness1338113_larkiness
leafiness1236483lea_finess
leakiness1337503lea_kiness
leeriness938323leer_iness
maltiness112910573_maltiness
martinets1138883_martinets
matiness102114753_ma_tiness
mealiness11310063mea_liness
merriness1138293me_rriness
nastiness92310573_nastiness
nattiness9239333_nattiness
nearness838313near__ness
neatness839153nea_t_ness
nerdiness10208333ne_rdiness
nerviness12226873ne_rviness
pastiness112312353_pastiness
perkiness15209163pe_rkiness
pertness10310093pe_rt_ness
pettiness1178703pe_ttiness
readiness102611853rea_diness
saltiness93312113_saltiness
scantiness1236883scantiness
scariness11310183scar_iness
seaminess11310473sea_miness
slatiness92511363sla_tiness
smarminess1444303smarminess
smartness1136143smart_ness
sportiness1278233sportiness
swarthiness1743383swarthiness
swartness1236113swart_ness
sweatiness1336463swea_tiness
tardiness10229923_tardiness
tarriness9229243_tarriness
tartness82210133_tart_ness
tastiness92311143_tastiness
tattiness9239413_tattiness
testiness9209753te_stiness
wariness11313213_war_iness
weakliness1753853weakliness
wealthiness1742853wealthiness
weariless1234763wear_iless

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 Filter1786911406030.440406115.9
2DLD Change Limit1406031187.17019609.9
3Display Results1181180.0502360.0
 (SQL Overall)1786911187.66023327.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.