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

254 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
harshen133928(None) 
harshens1437601harshens
harsher13310361harsher
arshin9312172_arshin
ashen87818672_a_shen
darshan1167062darshan
earthen1039252earthen
harden105718532har_den
harken135116342har_ken
harsh116418052harsh__
harshened1644452harshened
harshest14310192harshest
harshly1636272harshly
harslet10315652harslet
hashed136021942ha_shed
hashes125024802ha_shes
hasten95718562ha_sten
hausen9610382haus_en
hoarsen10367992hoars_en
larchen12479622larchen
marchen143312072marchen
marshes123615372marshes
oarsmen938092oarsmen
sarsen6314232sars_en
airshed11258533airshed
archean1269123_archean
arched125717323_arched
archer115016243_archer
arches114822043_arches
archon11311753_archon
arisen65316793_arisen
arpen74418043_ar_pen
arse46539273_ars_e_
arseno6318913_ars_eno
arses55733873_ars_es
arshins10312573_arshins
arsine64021043_arsine
arson55118833_ars_on
ashed97829773_a_shed
ashes86230613_a_shes
ashmen1168173_a_shmen
aspen75216093_a_spen
banshee121212453banshee
barchan1469133barchan
barmen105418533bar_men
barren85317613bar_ren
bashed126225703ba_shed
basher115123813ba_sher
bashes115631393ba_shes
batsmen1146883batsmen
birchen14347883birchen
brasher124515243brasher
brashes124518463brashes
burthen1236363burthen
careen84119493car_een
carmen104019343car_men
carse74934333cars_e_
carses85233653cars_es
carven114716663car_ven
cashed125124353ca_shed
cashes114729883ca_shes
cashew144311453ca_shew
chasten124312403cha_sten
coarsen93210323coars_en
crashed134214203crashed
crasher124616163crasher
crashes124618403crashes
darken114013443dar_ken
darshans1286543darshans
dashed115920563da_shed
dasheen1136393da_sheen
dasher104318983da_sher
dashes106124983da_shes
daysmen1335083daysmen
earshot10410823earshot
earthed1139923earthed
earthmen1346393earthmen
farther1348343farther
fashed136720253fa_shed
fashes124524023fa_shes
fasten95114893fa_sten
freshen133010883freshen
garden84215083gar_den
gashed116321973ga_shed
gasher104320373ga_sher
gashes105725153ga_shes
gasmen93111563ga_smen
girshes11248293girshes
gorhen1038893gor_hen
gurshes112210033gurshes
hackmen1836713hackmen
haen76229453ha___en
halogen1138393halogen
hamster12810423hamster
hangmen1337383hangmen
hanse85722793hans_e_
hansel95214373hans_el
hanses95022633hans_es
happen134812193ha_ppen
hapten115312983ha_pten
harassed1237113harassed
harasser1137033harasser
harasses11311033harasses
hardens113815023har_dens
harder105022403har_der
hardhat14411023hardhat
hardhead1645883hardhead
hardier114721543hardier
hardies114923233hardies
hardpan1336443hardpan
hardset113415833hardset
hardship1746033hardship
hare76255733har__e_
hared95742183har__ed
hareem114312063har_eem
harem104924453har__em
hares86255543har__es
harijan1735783harijan
harked145422553har_ked
harkens144112863har_kens
harmed125218833har_med
harmer114719553har_mer
harmin113117393har_min
harmine122816193harmine
harped124418403har_ped
harper115018403har_per
harpies123818313harpies
harpin113614383har_pin
harpoon1238313harpoon
harried113815533harried
harrier104417753harrier
harries103525493harries
harshening1744173harshening
harshness1545963harshness
harslets1137833harslets
hartshorn1543643hartshorn
haruspex2041683haruspex
hash106936503ha_sh__
hashing145020163ha_shing
haslet93222713ha_slet
hasped125014443ha_sped
hassel95614213ha_ssel
hassle93711593hassle_
hassled11358303hassled
hassles103411693hassles
haste85927863ha_ste_
hasted105125283ha_sted
hastens106214813ha_stens
hastes95727073ha_stes
hatched163414463hatched
hatchel153510753hatchel
hatcher153314723hatcher
hatches153420273hatches
hatchet153317563hatchet
hausens1077633haus_ens
haven114718533ha__ven
hawse116015123haws_e_
hawser125910843haws_er
hawses125113993haws_es
hayseed1435633hayseed
hazelhen2341623hazelhen
headsmen1465983headsmen
hearken14338023hear_ken
hearse94114273hears_e_
hearsed113811403hears_ed
hearses104414533hears_es
hearten102411753hear_ten
heathen133410893heathen
herdmen13238453herdmen
herdsmen1464833herdsmen
hirsel9138683hirs_el
hirsle9159573hirsle_
hirsled11118113hirsled
hirsles101510073hirsles
hoarse94411323hoars_e_
hoarsens11306023hoars_ens
hoarser10388393hoars_er
horse86132653hors_e_
horsed105321083hors_ed
horsemen1347483horsemen
horses94729343hors_es
horsey125115403hors_ey
horsier103013243horsier
horste94817413horste_
horstes104516113horstes
hosen85623883h_os_en
hushed134416673h_ushed
hushes124718593h_ushes
hyphen1736393h_yphen
kamseen1344013kamseen
kasher134915033ka_sher
khamseen1741813khamseen
larches124416443larches
lashed105625213la_shed
lasher94824533la_sher
lashes94831003la_shes
marched153813403marched
marcher143912973marcher
marches143921173marches
marishes13512553marishes
marksmen1644533marksmen
marse76231153mars_e_
marses84827113mars_es
marsh105320853marsh__
marshal1238973marshal
marshier1337593marshier
marshy14558333marsh_y
marten84518263mar_ten
mashed125325043ma_shed
masher114123203ma_sher
mashes115030003ma_shes
menshen1236803menshen
narthex1734263narthex
oarsman937733oarsman
parched154013693parched
parches143720003parches
parishes13314753parishes
parse75236993pars_e_
parsec105914483pars_ec
parsed96323893pars_ed
parser84822373pars_er
parses85534703pars_es
parsley1247793parsley
parson83817903pars_on
pashed125923143pa_shed
pashes115828393pa_shes
qurshes19228573qurshes
rasher95024123ra_sher
rashes95330153ra_shes
sarsens7311393sars_ens
sarsnet7314813sarsnet
sashed105622943sa_shed
sashes94728483sa_shes
sharpen12389723shar_pen
tarsier74119253tarsier
thrashed1555363thrashed
thrasher1455743thrasher
thrashes1487653thrashes
trashed113514703trashed
trasher104416133trasher
trashes104119263trashes
trashmen1346563trashmen
warden104515513war_den
warren95012853war_ren
warship1547833warship
warsle93112923warsle_
warsled112910443warsled
warsler10289893warsler
warsles103413643warsles
washed135521503wa_shed
washer124720393wa_sher
washes124425493wa_shes
worsen95513873wors_en
yardmen1335423yardmen

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.1401276364.3
2DLD Change Limit1340272546.06322105.7
3Display Results2542540.0932731.2
 (SQL Overall)1786912546.29628381.7
 
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.