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

185 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
halfness143556(None) 
haleness11312621haleness
baldness1137042baldness
calmness1236642calmness
halfnesses1636262halfnesses
haltless11308442haltless
hardness122411082hardness
harness102413932ha_rness
haziness20248512haziness
holiness112512502holiness
maleness10312312maleness
paleness10312992paleness
saltness82610242saltness
selfness1135152selfness
tallness837102tallness
aliners74717723_aliners
alines65735223_aline_s
almners9399563_almners
aloofness1242493_aloofness
aptness9268573_aptness
badness1039573ba_dness
balkiness1556903balkiness
balminess1356593balminess
baloneys1334663baloneys
bareness10912813bareness
baroness101210063baroness
baseness10910943baseness
bassness1096743bassness
boldness1136973boldness
caginess11310303caginess
cakiness1449553cakiness
canoness1039393canoness
chalones13312173chalone_s
chariness14310063chariness
chillness1455373chillness
coldness1137953coldness
daffiness1634843daffiness
daftness1235533daftness
dailiness1038673dailiness
dailyness1343643dailyness
dampness1336073dampness
dankness13256693dankness
darkness13247343darkness
deafness1236213deafness
dullness934873dullness
dulness8307983dul_ness
dwarfness1642793dwarfness
earliness939703earliness
easiness8313043easiness
fairness1136563fairness
falseness1236093falseness
farness102912203fa_rness
fastness11238763fastness
fatness103311293fa_tness
fellness1135913fellness
flatness1138153flatness
fullness1135443fullness
fulness10248963ful_ness
gameness112810693gameness
gaminess112911063gaminess
gastness9278483gastness
gayness1136843ga_yness
gladness1036153gladness
hackneys2033683hackneys
haffets1636053ha_ffets
hafters134614333ha_fters
hairiness1238013hairiness
hairless1157413hairless
hairnets1195633hairnets
halenesses13312043halenesses
halers94926923hal__ers
hales85449843hal__e_s
halest94823273hal__est
halfbeak2042373halfbeak
halfbeaks2142183halfbeaks
halftones1545223halftone_s
halides113416663halide_s
halites103221193halite_s
hallels103310133hal_lels
halloes104021523halloe_s
haloes94623863hal_oe_s
halogens1237363halogens
halons95720713halon__s
halters104619803hal_ters
halvers133311423hal_vers
halves124717093hal_ve_s
hamminess1635713hamminess
handiness132110933handiness
handless123512063handless
hangnest12311413hangnest
hangnests1344543hangnests
hanses95022633ha__nses
hapless123311333ha_pless
happiness1636003happiness
hardiness132310373hardiness
harmless1337403harmless
harshness1545963harshness
hastiness122410883hastiness
hatless103813443ha_tless
headiness132510363headiness
heaviness15207063heaviness
helmless1334273helmless
helpless1335063helpless
highness1536053highness
hilliness1248923hilliness
hiltless11297123hiltless
hipness12277383h_ipness
hoariness1238823hoariness
hokiness152510183hokiness
holeless1189363holeless
hominess132712463hominess
hoofless14258013hoofless
hotness1038613h_otness
huffiness1844283huffiness
hugeness1237373hugeness
hyalines14169333hyaline_s
idleness936843idleness
illness736473_illness
laciness102112553laciness
lameness102612673lameness
lankness12237043lankness
lateness82614073lateness
laxness1436043la_xness
laziness17239983laziness
madness10310073ma_dness
malines93625613maline_s
maltiness112910573maltiness
manliness111310123manliness
matiness102114753matiness
maziness19239543maziness
mealiness11310063mealiness
mildness1136523mildness
oiliness8311563oiliness
oldness836403_oldness
ovalness1134673oval_ness
packness1636933packness
palfreys1642003palfreys
pastness102510503pastness
patness92912283pa_tness
raciness102413453raciness
rankness12267943rankness
raptness1046733raptness
rareness81112853rareness
rashness1138093rashness
rawness1038153ra_wness
realness8410443real_ness
sadness8310613sa_dness
safeness11239633safeness
sageness92111983sageness
salines74029413saline_s
saltiness93312113saltiness
saltless8259343saltless
sameness102712683sameness
saneness82313723saneness
scaliness1149303scaliness
selfless1135013selfless
shadiness1337463shadiness
shakiness1637083shakiness
sharpness1434943sharpness
slyness1035263_slyness
smallness1174513smallness
soleness8814263soleness
staleness9310783staleness
talkiness1356913talkiness
tameness102411253tameness
tartness82210133tartness
tautness8217183tautness
ugliness936863ugliness
vainness1136063vainness
validness13125363validness
valines104520213valine_s
vastness11257293vastness
vileness1139983vileness
waeness102512783wa_eness
wanness102610683wa_nness
wariness11313223wariness
warmness1337063warmness
waviness1437723waviness
waxiness1836723waxiness
wellness1135793wellness
whatness1435093wha_tness
wholeness1545373wholeness
wildness1236203wildness
wiliness1139113wiliness
zaniness1738663zaniness

Search took 10 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 Limit1461621859.03316180.9
3Display Results1851850.0931989.2
 (SQL Overall)1786911859.54618718.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.