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

214 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
headset1131260(None) 
headsets1236051headsets
deadest93014882deadest
hadst93220222h_ads_t
handset113016822handset
hardset113415832hardset
headed114020472head_ed
header104422542head_er
headier113212952headier
headiest123015552headiest
headmen13259512headmen
headrest122910202headrest
heads95127112heads__
headsmen1465982headsmen
hearse94114272hearse_
hearsed113811402hearsed
hearses104414532hearses
heavyset1744092heavyset
wadset10314302_wadset
asset55932263__asset
basset85225383_basset
beaded104922423bead_ed
beader94623793bead_er
beadier103513913beadier
beadiest113815533beadiest
beadle93314683beadle_
beadles103414733beadles
beadmen12299453beadmen
beads85429503beads__
beadsmen1385883beadsmen
beast76338643bea_s_t
bedsit9312843be_dsit
beset76739133be__set
cadet85339343_cad_et
cease75227653cea_se_
ceased94920783cea_sed
ceases84427073cea_ses
cheapest1536073cheapest
deadbeat1245803deadbeat
deaden83714323dead_en
deader84220473dead_er
deadmen11248573deadmen
deads75726913deads__
deafest112911513deafest
dearest83618673dearest
eaglet73722583_eaglet
ease45042333_ea_se_
eased65430403_ea_sed
easel54521113_ea_sel
eases56041613_ea_ses
east46659103_ea_s_t
eldest72912683_eldest
fease84824873fea_se_
feased105718713fea_sed
feases95422923fea_ses
feast85932723fea_s_t
featest102715113featest
gadget93616183_gadget
haddest122711993h_addest
hade85440193h_ad_e_
haded105227623h_ad_ed
hades96035113h_ad_es
hadjee174111823h_adjee
hadjes175210403h_adjes
haet75659503h_a__et
haffet15311703h_affet
halest94823273h_alest
hamlet113722793h_amlet
handsel11308723handsel
handsets12258343handsets
hanse85722793h_anse_
hansel95214373h_ansel
hanses95022633h_anses
hardest113118413hardest
harslet10315653h_arslet
haslet93222713h_aslet
hassel95614213h_assel
hast76259483h_a_s_t
haste85927863h_a_ste
hausen9610383h_ausen
hawse116015123h_awse_
hawser125910843h_awser
hawses125113993h_awses
head87137173head___
headend12398363headend
headers113819393headers
headful1445563headful
headgate1346483headgate
headgear1343373headgear
headhunt1544693headhunt
headily1478623headily
heading122919113heading
headless12289863headless
headman13229633headman
headmost1445493headmost
headnote1245023headnote
headpin1336003headpin
headrests13245023headrests
headsail1244423headsail
headship1745743headship
headsman1446353headsman
headstay1543903headstay
headway1745553headway
heady125117263head__y
healed105121443hea_led
healer94221803hea_ler
heals85733453heals__
heaped124516903hea_ped
heaper114119523hea_per
heaps105223223heaps__
hearer94323643hea_rer
hearken14338023hearken
hears86737373hears__
hearsay1335523hearsay
heart85440743hea__rt
hearted113314023hearted
hearten102411753hearten
heat77061423hea___t
heated104525593hea_ted
heater94828303hea_ter
heathen133410893heathen
heather133914853heather
heats85838403heats__
heaume1137543heaume_
heaumes1237423heaumes
heave114521813hea_ve_
heaved134717863hea_ved
heaven123912603hea_ven
heaver124819673hea_ver
heaves124120303hea_ves
heavier13429423heavier
heavies132713873heavies
heaviest143210443heaviest
heddle114211163heddle_
heddles123311623heddles
heder95623643he_d_er
hedge105317353he_dge_
hedged125211813he_dged
hedger114912653he_dger
hedges115016263he_dges
heeded114215763heed_ed
heeder104216043heed_er
heeds95420423heeds__
heist87030913he_is_t
helmet113718933he_lmet
heppest14228143heppest
herded114215643herd_ed
herder104516463herd_er
herdmen13238453herdmen
herds96424683herds__
herdsmen1464833herdsmen
hest75950773he__s_t
hexade17438903hexad_e_
hexades18378703hexad_es
hexads17468193hexads__
hexose16267843hexose_
hexoses17228883hexoses
heydey1634633heyd_ey
hoarse94411323hoarse_
hoarsen10367993hoarsen
hoarser10388393hoarser
hoarsest1137133hoarsest
keyset13411533ke_yset
leaded84221543lead_ed
leaden74515223lead_en
leader74824653lead_er
leadier83212723leadier
leadiest93314983leadiest
leadmen10277903leadmen
leads66028493leads__
leadsmen1154793leadsmen
leaflet10199743leaflet
leanest7415863leanest
lease55230263lea_se_
leased74722883lea_sed
leaser65322673lea_ser
leases65428113lea_ses
least56134883lea_s_t
lewdest1136283lewdest
meads85425323meads__
meanest9315703meanest
mindset10313343mindset
nearest73415843nearest
neatest72516003neatest
pease75231113pea_se_
peasen84815963pea_sen
peases85229473pea_ses
readapt1039743readapt
readded103310733readded
reader73628293read_er
readied93316623readied
readier83117423readier
readies83324713readies
readiest93719043readiest
readmit1039823readmit
readopt10410843readopt
readout8615513readout
reads64835273reads__
realest73322433realest
reassert8313673reassert
reddest9311953reddest
reset55051863re__set
searest73322023searest
tasset65925313_tasset
tease55428713tea_se_
teased74721153tea_sed
teasel63914983tea_sel
teaser65421523tea_ser
teases65426273tea_ses
verset94327323ve_rset
wadsets1136443_wadsets
weakest1439003weakest
weasel93410523wea_sel
yeast85327943yea_s_t

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.406440125.6
2DLD Change Limit1340272146.70319995.1
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.18524870.0
 
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.