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 “halfheartednessa” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

53 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
halfheartedness2582391halfheartedness_
coldheartedness2273124coldheartedness_
warmheartedness2472484warmheartedness_
bigheartedness2163515_bigheartedness_
downheartedness2372945downheartedness_
halfhearted2152185halfhearted_____
halfheartedly2671725halfhearted___ly
hardheadedness2372965hardhea_dedness_
kindheartedness2473175kindheartedness_
openheartedness2173095openheartedness_
softheartedness2282845softheartedness_
trueheartedness1972675trueheartedness_
affectedness2153206_a_ffe_ctedness_
bullheadedness2172556bullhea_dedness_
calculatedness1961526calcula_tedness_
fatheadedness2163666fa_thea_dedness_
hardhandedness2372106hardh_andedness_
hotheadedness2163686h_othea_dedness_
learnedness1243866__l__earnedness_
abstractedness1962577_abstractedness_
adaptedness1553117_a___daptedness_
affectednesses2382607_a_ffe_ctednesses
alertness946057_al__e_rt__ness_
beardedness1544597____beardedness_
belatedness1444867bel___a_tedness_
boneheadedness2163487bonehea_dedness_
celebratedness1962177cel__ebratedness_
collectedness1863707col_le_ctedness_
concertedness1855837_conce_rtedness_
deliberateness1792687deliberate_ness_
eggheadedness2073287_egghea_dedness_
elatedness1146037_el___a_tedness_
exaggeratedness2582047exaggeratedness_
farfetchedness2671107farf_etchedness_
fatheadednesses2372627fa_thea_dednesses
haggardness1752337ha__ggar__dness_
haphazardness3171107ha_ph_azardness_
hearteners1346217____hearte_ners_
heartiness1338037____heart_iness_
hotheadednesses2363067h_othea_dednesses
illiterateness1472617illiterate_ness_
learnednesses1443647__l__earnednesses
literateness1256407__literate_ness_
longheadedness2063497longhea_dedness_
malapertness1661467malape_rt__ness_
offhandedness2462267_offh_andedness_
pervertedness1963277_perve_rtedness_
pigheadedness2163727_pighea_dedness_
pinheadedness2064177_pinhea_dedness_
relatedness1245607rel___a_tedness_
softheadedness2273167softhea_dedness_
swellheadedness2371927swellhea_dedness_
unaffectedness2372087unaffe_ctedness_

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 Filter178691950240.356501941.0
2DLD Change Limit95024537.41012823.8
3Display Results53530.0461152.2
 (SQL Overall)178691537.81222873.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.