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

176 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
hearkens1533669(None) 
harkens144112861h_arkens
hearken14338021hearken_
heartens113010151heartens
bedarkens1643392bedarkens
darkens12409872_darkens
hardens113815022h_ardens
harken135116342h_arken_
hearers104319782hear_ers
hearkened1744452hearkened
hearkener1644212hearkener
hearkeners1743982hearkeners
hearses104414532hearse_s
hearten102411752hearten_
heathens143210152heathens
heavens13439302hea_vens
hoarsens11306032hoarsens
weakens14367062wea_kens
arpens84814823__arpens
awakens14416153awa_kens
barkers134318513_barkers
barrens94414323_barrens
beakers134216873bea_kers
bearers94619593bear_ers
bearskins1543373bearskins
bedarken1544513bedarken_
berakes134815773berake_s
betokens14324573betokens
blackens16388103blackens
brackens16327923brackens
careens94514703_careens
cheapens15305943chea_pens
coarsens10348123coarsens
darken114013443_darken_
darkeys15356533_darkeys
deadens93410693dea_dens
deafens11317253dea_fens
dearies83526273dearie_s
dearness939973dearness
debarkers16164553debarkers
earless74316073_earless
earners74016453_earners
earns55927563_ear__ns
fearers104815273fear_ers
fearless1137873fearless
gardens93312093_gardens
gearless937373gearless
germens1078633ge_rmens
gherkins1643993ghe_rkins
hackees165014103h_ackees
hackers164619043h_ackers
haeres94017033haer_e_s
hakes126034303h_a_ke_s
hankers144218133h_ankers
happens14359173h_appens
haptens124511343h_aptens
harden105718533h_arden_
hareems12428203h_areems
harems115513823h_ar_ems
hares86255543h_ar_e_s
harked145422553h_arke_d
harkened1637483h_arkened
harkener1537573h_arkener
harkeners1636073h_arkeners
harking154120943h_arking
harks126333433h_ark__s
harmers124116593h_armers
harmins123716723h_armins
harness102413933h_arness
harpers124916203h_arpers
harpins123615703h_arpins
harshens1437603h_arshens
hastens106214813h_astens
hausens1077633h_ausens
havens124514043h_a_vens
hawkers174210333h_awkers
hawkeys20414703h_awkeys
headend12398363hea_dend
headends13326723hea_dends
headers113819393hea_ders
headless12289863headless
headmen13259513headmen_
headpins1436103headpins
headsets1236053headsets
healers104319463hea_lers
heapers123616673hea_pers
hearer94323643hear_e_r
hearing113324163hear_ing
hearings123611853hearings
hearkening1844533hearkening
hears86737373hear___s
hearsays1444513hearsays
hearse94114273hearse__
hearsed113811403hearse_d
hearsing1239383hearsing
hearted113314023hearte_d
heartened1347063heartened
heartener1256763heartener
hearteners1346213hearteners
hearths135311073hear_ths
hearties11315413hearties
hearting12513123hearting
heartless1236393heartless
hearts96218943hear__ts
heaters104225223hea_ters
heathen133410893heathen_
heathers143914733heathers
heatless113011463heatless
heaumes1237423heaume_s
heaven123912603hea_ven_
heavers133717193hea_vers
heaves124120303hea_ve_s
heavies132713873heavie_s
hegumens1444303hegumens
heiress1036813heir_ess
heirless1146053heirless
henries102718283henrie_s
heparins13310123hepar_ins
herders113914123he_rders
heres86245903he_r_e_s
herns84825583he_r__ns
heroes94923823he_roe_s
heroins103518013he_roins
herons94820543he_r_ons
herpes115517323he_rpe_s
herries104025073herrie_s
hoarders12307433hoarders
hoarsen10367993hoarsen_
jerkers18287083je_rkers
jerkins18358253je_rkins
krakens1034293kra_kens
larkers113014513_larkers
leadens83610983lea_dens
leakers113415423lea_kers
learners8398153learners
learns65513743lear__ns
leavens10409303lea_vens
markers133516103_markers
markets133314033_markets
martens93714953_martens
nearness838313nearness
neatens73310403nea_tens
parkers133816873_parkers
peahens12307573pea_hens
pearlers1039033pearlers
rearers74323563rear_ers
reawakens16263433reawakens
regreens9257453regreens
rehardens13104673rehardens
remarkers15197283remarkers
remarkets15224993remarkets
rewakens15406243rewakens
sarsens7311393_sarsens
sharkers154011053sharkers
sharpens13377813sharpens
shearers113911323shear_ers
shearlegs1342493shearlegs
slackens14367713slackens
smartens10286663smartens
sparkers144111313sparkers
starkers123712393starkers
tearers75218233tear_ers
tearless848713tearless
terreens8246533terreens
wakens135012043_wa_kens
wardens113711903_wardens
warrens103810893_warrens
weaken13349603wea_ken_
weakons14287803wea_kons
wearers104615903wear_ers
wearies103020223wearie_s
wheatens1454663whea_tens
yearend11285703year_end
yearends12234483year_ends
yearners11346373yearners
yearns9509543year__ns

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.420425454.8
2DLD Change Limit1461621767.39019778.3
3Display Results1761760.0802200.0
 (SQL Overall)1786911767.89022647.8
 
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.