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

79 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
health124712141health_
healths13478751healths
healthy16416081healthy
hearth125315212hearth_
hearths135311072hearths
heath115724282hea_th_
heaths126316382hea_ths
heathy156111212hea_thy
wealth12379222wealth_
wealths13365812wealths
wealthy16314332wealthy
altho86312603__altho
dealt65234283deal__t
dearth104212513dearth_
dearths11498843dearths
death94822523dea_th_
deaths105914443dea_ths
deathy134210233dea_thy
earth85023053_earth_
earths95014593_earths
earthy12399943_earthy
eath75735663_ea_th_
fealty122910223fealt_y
halest94823273h_alest
hallot95426783h_allot
halt76056303h_al__t
halted105019603h_alted
halter94420883h_alter
halts85230103h_alt_s
hath105933913h_a_th_
headlight1744323headlight
headset11312603headset
heal75645693heal___
healed105121443heal_ed
healer94221803heal_er
healers104319463healers
healing113922963healing
heals85733453heal__s
healthful1852423healthful
healthier1544253healthier
healthiest1645273healthiest
healthily1843103healthily
heart85440743hea__rt
hearted113314023hearted
hearten102411753hearten
hearts96218943heart_s
hearty126313633heart_y
heat77061423hea___t
heated104525593hea_ted
heater94828303hea_ter
heathen133410893hea_then
heather133914853hea_ther
heats85838403hea_t_s
heeltap1243723heeltap
height134713433he_ight
hellcat12410173hellcat
helmet113718933he_lmet
helot85332683he_l_ot
heth107028023he__th_
heths116317783he__ths
lealty92910603lealt_y
maltha1137503_maltha
neath86020283nea_th_
realest73322433realest
realist73225383realist
reallot7312133reallot
realter73716313realter
realtor73611353realtor
realty92713693realt_y
sealant73118303sealant
sealift10312793sealift
sheath12412883shea_th_
sheathe1348983shea_the
sheaths1358743shea_ths
stealth1096453stealth_
stealths11104123stealths
stealthy14103063stealthy
unhealthy1841943unhealthy
zealot15313473zeal_ot

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 Filter1786911340270.1601116818.8
2DLD Change Limit134027797.43618024.1
3Display Results79790.0302633.3
 (SQL Overall)178691797.62623431.8
 
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.