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

340 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
hearties1131541(None) 
heartier1139091heartier
heartiest12311101heartiest
beasties102514652beasties
beauties10229522beauties
dearies83526272dear_ies
fealties1139992fealties
hardies114923232h_ardies
harpies123818312h_arpies
harries103525492h_arries
hearses104414532hear_ses
hearted113314022heart_ed
hearten102411752heart_en
heartens113010152heartens
hearths135311072heart_hs
heartily1436562heartily
heartiness1338032heartiness
hearting12513122hearting
heartless1236392heartless
hearts96218942heart__s
heavies132713872hea_vies
henries102718282henr_ies
herries104025072he_rries
hertzes1938292he_rtzes
lealties8310792lealties
parties93230862_parties
realties8514852realties
smarties10312872smarties
wearies103020222wear_ies
yearlies1137602yearlies
aerates74627483aerat_es
aeries64737783ae_r_ies
armies85123693__armies
artier63419733__artier
artiest73121993__artiest
banties94324763_banties
barbies114519593_barbies
barites94322333_barites
bawties124214313_bawties
beanies93821093bea_nies
beastie92412433beastie_
bedirties1275683bedirties
berates94126853berat_es
berries94423553be_rries
bheesties1443923bheesties
blasties102113623blasties
caries85147623_car_ies
carnies94123963_carnies
carries94328013_carries
cartes86239473_cart_es
catties94023053_catties
cecities12312043cecities
cerates95428233cerat_es
ceratins102818723ceratins
cerites94823433ce_rites
certes84623083ce_rt_es
chanties132615803chanties
charities14312733charities
charlies133414223charlies
cheapies1539033chea_pies
cherries131812973che_rries
chertier1387873che_rtier
chertiest1438793che_rtiest
claries93422203clar_ies
clarities11312483clarities
darbies104216983_darbies
darkies124015753_darkies
dartles84014133_dartles
dauties83315763_dauties
dawties113312703_dawties
dearie73319813dear_ie_
dearths11498843deart_hs
decries103319803decr_ies
deities82621923de_ities
departees1265723departees
deputies1157533deputies
derates84028883derat_es
derbies103016053de_rbies
derries83124623de_rries
diaries83321953diar_ies
dirties83119383_dirties
drearies92313413drear_ies
earlier72612743_earlier
earliest82415243_earliest
earthed1139923_earthed
earthen1039253_earthen
earthier1137443_earthier
earthiest1259103_earthiest
earths95014593_eart_hs
earwigs11104413_earwigs
easies64126633_ea_sies
ecartes94212563ecart_es
empties11712243_empties
entries71523163_entries
eyries93816813_eyr_ies
faeries104118993faer_ies
farcies125317883_farcies
fatties103018203_fatties
ferities111416713ferities
ferlies103216693fe_rlies
ferries103521083fe_rries
ferrites112312823ferrites
forties104323863_forties
gentries91315263gentries
gharries12318203gharries
hackies163418243h_ackies
haeredes1246333haeredes
haeres94017033haer__es
halites103221193h_alites
hamartias14115353hamartias
hankies143617763h_ankies
hantles104117513h_antles
hardier114721543h_ardier
hardiest123416333h_ardiest
hares86255543h_ar__es
harmines132715133h_armines
harmins123716713h_armins
harpins123615703h_arpins
harried113815533h_arried
harrier104417753h_arrier
harriers113712433h_arriers
hartals10313023h_artals
harts88441593h_art__s
hastes95727073h_ast_es
hastier103916623h_astier
hastiest112916493h_astiest
hates86742573h_a_t_es
havartis1444373havarti_s
hawkies173311243h_awkies
headier113212953hea_dier
headiest123015553hea_diest
headlines13118993headlines
headpins1436103headpins
headraces1546613headraces
healthier1544253healthier
healthiest1645273healthiest
healths13478753healt_hs
hearer94323643hear__er
hearers104319783hear_ers
hearing113324163hear_ing
hearings123611843hearings
hearken14338023hear_ken
hearkens15336693hearkens
hears86737373hear___s
hearsays1444513hearsays
hearse94114273hear_se_
hearsed113811403hear_sed
hearsing1239383hearsing
heart85440743heart___
heartaches1844043heartaches
heartbeat1444633heartbeat
heartbeats1552773heartbeats
heartened1347063heartened
heartener1256763heartener
hearteners1346213hearteners
heartfelt1543263heartfelt
heartfree1543273heartfree
hearth125315213heart__h
heartsease1352303heartsease
heartsick1842483heartsick
hearty126313633heart__y
heated104525593hea_t_ed
heater94828303hea_t_er
heaters104225213hea_ters
heathen133410893hea_then
heathens143210153hea_thens
heather133914853hea_ther
heathers143914733hea_thers
heathier1438343heathier
heathiest1549383heathiest
heaths126316383hea_t_hs
heating114024323hea_ting
heatless113011463hea_tless
heats85838403hea_t__s
heaumes1237423hea_umes
heaves124120303hea__ves
heavier13429423hea_vier
heaviest143210443hea_viest
hebraizes2344103hebraizes
heftier1337203he_ftier
heftiest1439183he_ftiest
hegaris11310423hegar_i_s
heinies102514543he_inies
helotries1269563helotries
hematics151712193hematics
hematines141312183hematines
hematins131714663hematins
hematites141510793hematites
heparins13310123hepar_ins
hepatics15198933hepatics
hepatizes2347823hepatizes
herbier1239593he_rbier
herbiest1339993he_rbiest
herdics13249523he_rdics
heredes11313133he_redes
heres86245903he_r__es
heresies11312693heresies
heretics13310503heretics
hermits12312133he_rmits
hernias10310773he_rnias
heroes94923823he_r_oes
heroics122912003he_roics
heroines112916573he_roines
heroins103518013he_roins
heroizes202610983he_roizes
herpes115517323he_r_pes
herried113514453he_rried
hessites1138613hessites
hexarchies2543863hexarchies
hilarities1347153hilarities
hoagies112811993hoa_gies
hoarier104211743hoar_ier
hoariest11312883hoar_iest
hogties112813993h_ogties
hotties103016953h_otties
hourlies1138343hourlies
hurdies114015663h_urdies
hurlies103315333h_urlies
hurries103919653h_urries
hurtles103913753h_urtles
hyalites14208833hyalites
jerkies183411583je_rkies
jerries143817513je_rries
jetties143613123je_tties
keratins122313473keratins
kerries113317913ke_rries
laities7320343_laities
learier73415663lear_ier
leariest83117843lear_iest
lefties10312073le_fties
lenities8315943lenities
levities11310713levities
marries93825283_marries
martins93322063_martins
mealies92821933mea_lies
mealtimes1345243mealtimes
meanies93620743mea_nies
meantimes1345883meantimes
meatier93214613mea_tier
meatiest102816793mea_tiest
mercies113817563me_rcies
nasties73520493_nasties
nearlier836793nearlier
nearliest949353nearliest
nearsides1044513nearsides
neckties1445903neckties
ovaries10312653ovar_ies
panties94230933_panties
paries84742513_par_ies
parities10522973_parities
parries93925843_parries
partied103516553_partied
partier93520713_partier
partiers103514243_partiers
pasties94529813_pasties
patties93425143_patties
pearlier1037313pearlier
pearliest1139343pearliest
pearlites1138213pearlites
pearter9412743peart_er
peartest10311293peart_est
peartness1137773peartness
peatier94017233pea_tier
peatiest103118803pea_tiest
peavies122213393pea_vies
peeries93623023peer_ies
peltries10313023peltries
penalties11139483penalties
perries93226603pe_rries
phratries1447583phratries
platies93722543pla_ties
quarries1749943quarries
quartes163314933quart_es
quartics19216843quartics
quartier1737543quartier
quartiers1845183quartiers
quartiles1845603quartiles
quartzes2645453quartzes
rarities8316333_rarities
readies83324703rea_dies
realities9316303realities
reargues936713reargues
recarries1147863recarries
redries83721713redr_ies
refries104419733refr_ies
remarries1147673remarries
repartees1147253repartees
reties65436193re__ties
retries74129073retr_ies
rewrites11311053rewrites
salties73725773_salties
scanties103215413scanties
searches132112903searches
sentries81318053sentries
series64540973se_r_ies
serries73925353se_rries
shanties113116573shanties
sharpies13411223sharpies
sheathes14610183shea_thes
shelties111111373she_lties
sherries111812893she_rries
shorties11414573shorties
shvartzes2442093shvartzes
smartie9310163smartie_
sorties74126403_sorties
startles82111963startles
tardies84225863_tardies
tarries73324263_tarries
tartier74123263_tartier
tartiest82718313_tartiest
tatties74120343_tatties
tearier73815613tear_ier
teariest82417263tear_iest
teatimes1039443tea_times
terries73425613te_rries
thearchies1844423thearchies
theatres11298633thea_tres
theatrics1444773theatrics
theories11311593theor_ies
therapies1447713therapies
theurgies1343353theurgies
thirties1139723thirties
treaties8316983trea_ties
varies94330873_var_ies
veeries102916883veer_ies
verites103822253ve_rites
verities111418043verities
vertices13612273ve_rtices
vestries11314043vestries
wartier103413913_wartier
wartiest113614643_wartiest
wartimes1336963_wartimes
wearied112911803wear_ied
wearier103613283wear_ier
weariest112914793wear_iest
weirdies12255783weirdies
wherries14179023whe_rries
yeastier1135393yeastier
yeastiest1237203yeastiest
zeatins16311733zea_tins

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.190940478.9
2DLD Change Limit1461623409.21615859.6
3Display Results3403400.2361440.7
 (SQL Overall)1786913409.64218532.6
 
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.