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

266 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
healths1347875(None) 
health124712141health_
healthy16416081healthy
hearths135311071hearths
heaths126316381hea_ths
wealths13365811wealths
dearths11498842dearths
deaths105914442dea_ths
earths95014592_earths
halts85230102h_alt_s
healers104319462healers
heals85733452heal__s
hearth125315212hearth_
hearts96218942heart_s
heath115724282hea_th_
heathy156111212hea_thy
heats85838402hea_t_s
heths116317782he__ths
sheaths1358752shea_ths
stealths11104122stealths
wealth12379222wealth_
wealthy16314332wealthy
altho86312603__altho
altos55822953__altos
alts46639903__alt_s
baths105922923_ba_ths
beasts84519723beast_s
beats76042243bea_t_s
beauts86015283beaut_s
belts75931163be_lt_s
berths114712423be_rths
beths105519223be__ths
breadths1474463breadths
breaths124411183brea_ths
celts75325783ce_lt_s
chalahs15289883chalahs
chalehs15268803chalehs
cheats114519543chea_t_s
chelates132713843chelates
cheths14389823che__ths
coolths1236013coolths
daleths1135323_daleths
dealates92716683dealates
dealers84118613dealers
deals65435343deal__s
dealt65234283dealt__
dearth104212513dearth_
death94822523dea_th_
deathy134210233dea_thy
delates83526283delates
deltas74414823de_ltas
delts65731793de_lt_s
depths12428573de_pths
desalts839573desalt_s
earth85023053_earth_
earthy12399943_earthy
easts57530323_east_s
eath75735663_ea_th_
eats47054873_ea_t_s
elates65032363_elates
eoliths10318573_eoliths
eths76619523_e__ths
exalts13328313exalt_s
faiths124610273_faiths
fealties1139993fealties
fealty122910223fealt_y
feasts95116093feast_s
feats86432753fea_t_s
fellahs13428393fellahs
felts85324543fe_lt_s
filths12389783_filths
galahs105512673_galahs
garths104111503_garths
gelates83219583gelates
gelatis83313513gelatis
gelatos83111513gelatos
gelts65924613ge_lt_s
hadiths1436023hadiths
haets86525123h_aet_s
hafts116219463h_aft_s
hahs108333363h_a__hs
halalahs14367443halalahs
halals95018313h_alals
halers94926913h_alers
hales85449843h_al_es
halids104016133h_alids
halites103221193h_alites
halitus10339963h_alitus
hallahs133912463hallahs
hallos95425103h_allos
halls85633783h_al_ls
halmas117017893h_almas
halms105225213h_al_ms
haloes94623863h_aloes
halons95720713h_alons
halos85230253h_al_os
halt76056303h_alt__
halted105019603h_alted
halter94420883h_alter
halters104619803h_alters
halvahs16417533h_alvahs
halvas124714173h_alvas
halves124717093h_alves
hants86335403h_ant_s
harts88441593h_art_s
hastes95727073h_astes
hates86742573h_a_tes
hath105933913h_a_th_
hats76858253h_a_t_s
haughs13408563h_aughs
headers113819393headers
headless12289863headless
heads95127113hea__ds
heal75645693heal___
healed105121443heal_ed
healer94221803heal_er
healing113922963healing
healthful1852423healthful
healthier1544253healthier
healthiest1645273healthiest
healthily1843103healthily
heapers123616673heapers
heaps105223223hea__ps
hearers104319783hearers
hears86737373hea__rs
hearses104414533hearses
heart85440743heart__
hearted113314023hearted
hearten102411753hearten
heartens113010153heartens
hearties11315413hearties
hearty126313633heart_y
heat77061423hea_t__
heated104525593hea_ted
heater94828303hea_ter
heaters104225223heaters
heathen133410893hea_then
heathens143210153hea_thens
heather133914853hea_ther
heathers143914733hea_thers
heatless113011463heatless
heaumes1237423heaumes
heavens13439303heavens
heavers133717193heavers
heaves124120303hea_ves
heavies132713873heavies
heelers103815623heelers
heels85625533heel__s
heeltap1243723heeltap
heeltaps1343073heeltaps
hefts116218153he_ft_s
hehs106723963he___hs
heighths14324823heighths
heights14399443heights
heils85222193heil__s
heists96814633heist_s
helios94816633he_lios
hellers103619833hellers
hellish13310723hellish
helloes103717463helloes
hellos95321683he_llos
hells85032043he_l_ls
helms105619463he_l_ms
helos84928063he_l_os
helots95217703he_lots
helps105219343he_l_ps
helves124316063he_lves
henleys1334843henleys
hents87330743he_nt_s
heralds1137713heral_ds
herls85226433herl__s
hests85829933he_st_s
heth107028023he__th_
hets75547203he__t_s
heuchs14447923he_uchs
heughs13516903he_ughs
hiatus938223hia_tus
highths13358003highths
hilts86924413h_ilt_s
holts85627913h_olt_s
hyalins13229273hyalins
hyalites14208833hyalites
inearths1144933inearths
jealous1438093jealous
keblahs1634563keblahs
kelts95222633ke_lt_s
kheths16495973khe__ths
laths86022403_la_ths
lealties8310793lealties
lealty92910603lealt_y
leasts64616413least_s
lengths1144083lengths
maltha1137503_maltha
malthas1237913_malthas
malts76331753_malt_s
maths105624023_ma_ths
mealies92821933mealies
meals75933373meal__s
meats75034053mea_t_s
meatus85112923mea_tus
megaliths1544743megaliths
melts74930103me_lt_s
meths105320233me__ths
neath86020283nea_th_
neats55931903nea_t_s
neoliths1144933neoliths
oaths86117313_oa_ths
paths105521383_pa_ths
peals75235493peal__s
peats76140193pea_t_s
pelts76128813pe_lt_s
ralphs1135373_ralphs
reacts83616603react_s
reales64934123real_es
realms84913493real_ms
reals55038653real__s
realter73716313realter
realters83614043realters
realties8514853realties
realtor73611353realtor
realtors82811683realtors
realty92713693realt_y
reatas64021013rea_tas
relates73731433relates
rialtos736613rialtos
salts55431883_salt_s
sealers74323553sealers
seals54839693seal__s
seats54844343sea_t_s
selahs9313213se_lahs
sheals94420643sheal__s
sheath12412893shea_th_
sheathe1348993shea_the
sheathes14610193shea_thes
sheltas10279673she_ltas
smaltos9408193smaltos
smalts85214893smalt_s
snaths95112913sna_ths
spilths12356023spilths
stealth1096453stealth_
stealthy14103063stealthy
swarths13537323swarths
swaths125312643swa_ths
teals56234133teal__s
teats55636813tea_t_s
tenths94412663te_nths
teths85418513te__ths
tilths9459373_tilths
unearths1144353unearths
unhealthy1841943unhealthy
vealers103214293vealers
veals84926193veal__s
wealds10459103weal_ds
weals85428743weal__s
welts85225193we_lt_s
wheals124512523wheal__s
wheats125013223whea_t_s
wraiths1355033wraiths
wraths123810083wra_ths
wreaths13338373wrea_ths
yeahs115214553yea__hs
yeasts96413053yeast_s
zealots1636763zealots
zealous1637813zealous
zeals145320853zeal__s
zeniths1935153zeniths

Search took 7 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 Limit1340272666.56020430.9
3Display Results2662660.0803325.0
 (SQL Overall)1786912666.80026278.1
 
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.