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

145 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
headsets123605(None) 
headset11312601headset_
handsets12258342handsets
headers113819392head_ers
headiest123015552headiest
headless12289862headless
headrest122910202headrest
headrests13245022headrests
hearses104414532hearse_s
wadsets1136442_wadsets
assets65617663__assets
bassets96414823_bassets
beaders104120183bead_ers
beadiest113815533beadiest
beadles103414733beadle_s
beasts84519723bea_s_ts
bedsits1037563be_dsits
besets85718803be__sets
cadets96316513_cad_ets
ceases84427073cea_se_s
deadbeats1343683deadbeats
deadens93410693dead_ens
deadest93014883deadest_
deadness1039233deadness
eaglets84111663_eaglets
easels65914553_ea_sels
eases56041613_ea_se_s
easts57530323_ea_s_ts
feases95422923fea_se_s
feasts95116093fea_s_ts
gadgets10348683_gadgets
haddest122711993h_addest
hades96035113h_ad_e_s
hadjees18356383h_adjees
hadjes175210403h_adje_s
hadst93220223h_ads_t_
haets86525123h_a__ets
haffets1636053h_affets
hamlets123211403h_amlets
handsels12317243handsels
handset113016823handset_
hansels104011653h_ansels
hanses95022633h_anse_s
hardset113415833hardset_
harslets1137833h_arslets
haslets102510863h_aslets
hassels104311013h_assels
hastes95727073h_a_stes
hausens1077633h_ausens
hawsers13409483h_awsers
hawses125113993h_awse_s
headdress1443753headdress
headed114020473head_e_d
headend12398363head_end
headends13326723headends
header104422543head_e_r
headfuls1544313headfuls
headgate1346483headgate
headgates1446383headgates
headgear1343373headgear
headgears1443153headgears
headhunts1643123headhunts
headier113212953headie_r
headiness132510363headiness
headings133510493headings
headmen13259513headme_n
headmost1445493headmost
headnote1245023headnote
headnotes1344653headnotes
headpins1436103headpins
heads95127113head___s
headsail1244423headsail
headsails1343943headsails
headship1745743headship
headships1845673headships
headsman1446353headsman
headsmen1465983headsmen
headstay1543903headstay
headstays1643563headstays
headways1845003headways
healers104319463hea_lers
heapers123616673hea_pers
hearers104319783hea_rers
hearkens15336693hearkens
hearsays1444513hearsays
hearse94114273hearse__
hearsed113811403hearse_d
heartens113010153heartens
hearts96218943hea__rts
heaters104225223hea_ters
heathens143210153heathens
heathers143914733heathers
heatless113011463heatless
heats85838403hea___ts
heaumes1237423heaume_s
heavens13439303hea_vens
heavers133717193hea_vers
heaves124120303hea_ve_s
heavies132713873heavie_s
heaviest143210443heaviest
heavyset1744093heavyset_
heddles123311623heddle_s
heders104119763he_d_ers
hedgers124310253he_dgers
hedges115016243he_dge_s
heeders114213743heed_ers
heedless12278813heedless
heists96814633he_is_ts
helmets12309073he_lmets
herders113914123herd_ers
hests85829933he__s_ts
hexades18378703hexad_e_s
hexoses17228883hexose_s
heydeys1732863heyd_eys
hoarsens11306023hoarsens
hoarsest1137133hoarsest
keysets1434343ke_ysets
leadens83610983lead_ens
leaders83819603lead_ers
leadiest93314983leadiest
leadless9248793leadless
leaflets11244813leaflets
leasers74717843lea_sers
leases65428113lea_se_s
leasts64616413lea_s_ts
mindsets1135683mindsets
peases85229473pea_se_s
readapts1145583readapts
readers83823773read_ers
readies83324713readie_s
readiest93719043readiest
readmits1136653readmits
readopts1146493readopts
readouts938903readouts
reasserts945983reasserts
reassess836513reassess
resets65427613re__sets
tassets75012773_tassets
teasels74311313tea_sels
teasers75317243tea_sers
teases65426273tea_se_s
versets103913103ve_rsets
wadset10314303_wadset_
weasels10468503wea_sels
yeasts96413053yea_s_ts

Search took 9 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.343520965.0
2DLD Change Limit1461621458.09318060.3
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.49921024.9
 
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.