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

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

72 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
hasteful1410525(None) 
hateful13107681ha_teful
tasteful11115211tasteful
wasteful14104931wasteful
easeful1037292eas_eful
fateful1397512fa_teful
ghastful1543302ghast_ful
hatful12108742ha_t_ful
hatsful13106192ha_tsful
masterful1443652masterful
artful968273_art_ful
baleful1237993ba_leful
baneful1237893ba_neful
bashful1556553bas_hful
basinful1343223basinful
basketful1852133basketful
boastful1344853boast_ful
cageful1356483ca_geful
careful1249113ca_reful
chanceful1942763chanceful
changeful1842593changeful
chestful1644243chest_ful
dareful1157053da_reful
factful1536373fact_ful
faithful1743383faithful
feastful1444923feast_ful
fistful1365903fist_ful
grateful1245403grateful
handful14127253ha_ndful
handsful1544083handsful
harmful1535763ha_rmful
hassel95614213hasse__l
haste85927863haste___
hasted105125283haste__d
hasten95718563haste__n
hastened12239103hastened
hastener11259133hastener
hastens106214813haste_ns
hastes95727073haste__s
hatefully1844773ha_tefully
hatfuls1386023ha_t_fuls
hauteur1033893haute_ur
healthful1852423healthful
hopeful1545903h_opeful
hostel93914153hoste__l
houseful1445473houseful
hurtful1344853hurt_ful
hushful1644333hus_hful
jestful1745333jest_ful
kistful1465303kist_ful
ladleful1243273ladleful
lustful1045283lust_ful
matterful1443193matterful
museful1245883mus_eful
pageful1346353pa_geful
pastel85918713paste__l
pasteup1134983paste_up
plateful1345433plateful
restful1038623rest_ful
shameful1644283sha_meful
spiteful1344303spiteful
tableful1344153tableful
tactful1236163tact_ful
tastefully1653483tastefully
useful947013_us_eful
vatful12107083va_t_ful
waeful1238123wa__eful
wakeful1735613wa_keful
wameful1535673wa_meful
wastefully1943433wastefully
wistful1365713wist_ful
zestful1945243zest_ful

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.1561145455.1
2DLD Change Limit146162727.80018738.7
3Display Results72720.0302400.0
 (SQL Overall)178691727.98622375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.