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

484 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
harsher1331036(None) 
harshen1339281harshen
archer115016242_archer
basher115123812ba_sher
brasher124515232brasher
crasher124616152crasher
dasher104318982da_sher
farther1348342farther
gasher104320372ga_sher
hamster12810422hamster
harasser1137032harasser
harder105022402har_der
hardier114721542hardier
harmer114719552har_mer
harper115018402har_per
harrier104417752harrier
harsh116418052harsh__
harshens1437602harshens
harshest14310192harshest
harshly1636272harshly
harslet10315652harslet
hashed136021942ha_shed
hashes125024802ha_shes
hatcher153314722hatcher
hawser125910842haws_er
hoarser10388392hoars_er
horsier103013242horsier
kasher134915032ka_sher
lasher94824532la_sher
marcher143912972marcher
marshes123615372marshes
marshier1337592marshier
masher114123202ma_sher
parser84822372pars_er
rasher95024112ra_sher
tarsier74119252tarsier
thrasher1455732thrasher
trasher104416122trasher
warsler10289892warsler
washer124720392wa_sher
aether94213673_aether
airshed11258533airshed
answer936893_answer
anther93715063_anther
arched125717323_arched
archers124414573_archers
archery15478063_archery
arches114822043_arches
arguer74510543_arguer
arider74717743_arider
armer76924443_ar_mer
arse46539273_ars_e_
arses55733873_ars_es
arshin9312173_arshin
artier63419733_artier
artsier768943_artsier
ashed97829773_a_shed
ashen87818673_a_shen
ashes86230613_a_shes
ashier94714833_a_shier
ashler9459973_a_shler
asker96418783_a_sker
asper75520433_a_sper
aster55434893_a_ster
banisher13169183banisher
banshee121212453banshee
barber104419323bar_ber
barer74535803bar__er
barker124822863bar_ker
barkier133814483barkier
barmier114313043barmier
barnier93213673barnier
barrier94017733barrier
barter85525373bar_ter
baser74828923ba_s_er
bashed126225703ba_shed
bashers124820833ba_shers
bashes115631393ba_shes
baster85333593ba_ster
batcher144414853batcher
bather115322513ba_ther
blusher124113113blusher
brashes124518463brashes
brashier13389933brashier
brasier94516753brasier
brusher123813003brusher
burgher1337003burgher
burster9310293burster
busher114922203_busher
carder94524183car_der
career85822243car_eer
carer74942333car__er
caresser1038803caresser
caroler93816753caroler
carper104923633car_per
carrier93619583carrier
carse74934333cars_e_
carses85233653cars_es
carter84932273car_ter
carver114420143car_ver
cashed125124353ca_shed
cashes114729883ca_shes
cashew144311453ca_shew
cashier123713323ca_shier
caster85232573ca_ster
catcher143115823catcher
causer84117783caus_er
charger133914063char_ger
charier124317903char_ier
charmer144913663char_mer
charrier1378683charrier
charter123918303char_ter
chaser114918383cha_s_er
chaster124718503cha_ster
cherisher1765233cherisher
clasher124615513clasher
coarser93211193coars_er
cosher114819903_cosher
crashed134214203crashed
crashers134013223crashers
crashes124618403crashes
crasser94114333crasser
crusher124412323crusher
curser84721473curs_er
dabster1036703dabster
darer65230793dar__er
darker114718693dar_ker
darner74017303dar_ner
darshan1167063darshan
darter75320363dar_ter
dashed115920563da_shed
dashers115016863da_shers
dashes106124983da_shes
dashier114311183da_shier
dorser74819173dors_er
earlier72612743earlier
earner63617223ear_ner
earshot10410823earshot
earthed1139923earthed
earthen1039253earthen
earthier1137443earthier
easier64218463ea_sier
easter65027983ea_ster
eraser64216333eras_er
falser93912413fals_er
farcer115016083far_cer
farer86733143far__er
farmer115017373far_mer
farrier103514883farrier
fashed136720253fa_shed
fashes124524023fa_shes
faster94625773fa_ster
father125116713fa_ther
fisher124917143_fisher
flasher133914063flasher
flesher133610923flesher
flusher133012273flusher
fresher132612643fresher
further1337003further
gagster9317633gagster
garbler104012563garbler
gargler93710263gargler
garner73917003gar_ner
garnisher13195853garnisher
garter74420513gar_ter
gashed116321973ga_shed
gashes105725153ga_shes
gasper94515543ga_sper
gasser75017773ga_sser
gassier83812573gassier
gaster75027353ga_ster
gather104115853ga_ther
gaucher1337233gaucher
girshes11248293girshes
gorsier83811073gorsier
grasper10389783grasper
gurshes112210033gurshes
gusher104115773_gusher
hacker154822693ha_cker
hackler163512353hackler
hafter124815883ha_fter
haggler12328933haggler
hagrider1334483hagrider
hailer94720343ha_iler
hairier103111053hairier
haler85033523ha__ler
halter94420883ha_lter
hammer138120033ha_mmer
hammier143510653hammier
hamper134518653ha_mper
hamsters13710423hamsters
hanaper1237133hanaper
hander104526433ha_nder
handier113817443handier
handler113516163handler
hanger104023253ha_nger
hanker134622093ha_nker
hanse85722793hans_e_
hansel95214373hans_el
hanses95022633hans_es
happier143312033happier
harassed1237113harassed
harassers1246193harassers
harasses11311033harasses
harbor11410723har_bor
harborer1348053harborer
harbour1247053harbour
harden105718533har_den
hardener1238883hardener
hardhat14411023hardhat
hardhead1645883hardhead
hardies114923233hardies
hardset113415833hardset
hardship1746023hardship
hare76255733har__e_
hared95742183har__ed
hareem114312063har_eem
harem104924453har__em
hares86255543har__es
harked145422553har_ked
harken135116343har_ken
harkener1537573harkener
harmed125218833har_med
harmers124116593har_mers
harped124418403har_ped
harpers124916203har_pers
harpies123818313harpies
harried113815533harried
harriers113712433harriers
harries103525493harries
harrower1446363harrower
harshened1644453harshened
harshness1545963harshness
harslets1137833harslets
hartshorn1543643hartshorn
haruspex2041683haruspex
harvester1544333harvester
hash106936503ha_sh__
haslet93222713ha_slet
hasped125014443ha_sped
hassel95614213ha_ssel
hassle93711593hassle_
hassled11358303hassled
hassles103411693hassles
haste85927863ha_ste_
hasted105125283ha_sted
hasten95718563ha_sten
hastes95727073ha_stes
hastier103916623hastier
hatched163414463hatched
hatchel153510753hatchel
hatchers163113173hatchers
hatchery19326383hatchery
hatches153420273hatches
hatchet153317563hatchet
hater85034753ha__ter
hatter94724873ha_tter
hauler95015123ha_uler
haulier1059943haulier
haunter103111153haunter
hausen9610383haus_en
haver115124463ha__ver
hawker164812663ha_wker
hawse116015123haws_e_
hawsers13409483haws_ers
hawses125113993haws_es
hayer114620243ha__yer
hayseed1435633hayseed
hazer174820233ha__zer
hazier184712403ha_zier
hearer94323643hear__er
hearse94114273hears_e_
hearsed113811403hears_ed
hearses104414533hears_es
heartier1139093heartier
heather133914853heather
heister103613623heister
herbier1239593herbier
herder104516463her_der
higher134610893h_igher
hipster12288783hipster
hirer85423123hir__er
hirsel9138683hirs_el
hirsle9159573hirsle_
hirsled11118113hirsled
hirsles101510073hirsles
hisser94713793h_isser
hissier103410503hissier
hitcher153712003hitcher
hither124417253h_ither
hoarder11329233hoar_der
hoarier104211743hoar_ier
hoarse94411323hoars_e_
hoarsen10367993hoars_en
hoister103714203hoister
holster103512213holster
hornier103012453hornier
horse86132653hors_e_
horsed105321083hors_ed
horses94729343hors_es
horsey125115403hors_ey
horste94817413horste_
horstes104516113horstes
hoser811529763h_os_er
hosier94219613h_osier
houser95322283hous_er
hurdler113610003hurdler
hurler94717223hur_ler
hurrier103412933hurrier
hurter93915853hur_ter
hushed134416673h_ushed
hushes124718593h_ushes
husker134212703h_usker
jasper154610383ja_sper
josher164312963_josher
kaiser103610373kais_er
kashers143914023ka_shers
kosher134412973_kosher
lamster9109913lamster
lapser84113143laps_er
larchen12479623larchen
larches124416443larches
larder73720973lar_der
lardier83518343lardier
larger74417513lar_ger
larker104519243lar_ker
larkier113711523larkier
laser54633323la_s_er
lashed105625213la_shed
lashers104121833la_shers
lashes94831003la_shes
lassoer7379383lassoer
laster64830633la_ster
lather95124353la_ther
laugher1136603laugher
lavisher1445083lavisher
lurcher12338133lurcher
lusher93818763_lusher
marbler113511673marbler
marched153813403marched
marchen143312073marchen
marchers153710813marchers
marches143921173marches
mariner93315993mariner
marishes13512553marishes
marker124420393mar_ker
markhor1635463markhor
marlier92614773marlier
marrer83716673mar_rer
marrier93817523marrier
marse76231153mars_e_
marses84827113mars_es
marsh105320853marsh__
marshal1238973marshal
marshy14558333marsh_y
maser75029973ma_s_er
mashed125325043ma_shed
mashers124621053ma_shers
mashes115030003ma_shes
masker124416103ma_sker
massier93615223massier
master84831343ma_ster
matcher143214283matcher
mosher114719793_mosher
murther1237953murther
musher113820573_musher
narthex1734263narthex
norther1039733norther
nosher94616363_nosher
nurser64314503nurs_er
oarsmen938093oarsmen
panther12611443panther
parader103914863parader
parched154013693parched
parches143720003parches
pardner10239473pardner
parer75839903par__er
parishes13314753parishes
parker124121373par_ker
parrier93717653parrier
parse75236993pars_e_
parsec105914473pars_ec
parsed96323893pars_ed
parsers94118153pars_ers
parses85534703pars_es
parsley1247793parsley
partier93520713partier
partner92811393partner
partyer12337873partyer
pashed125923143pa_shed
pashes115828393pa_shes
passer84721033pa_sser
paster85734373pa_ster
patcher143515143patcher
pauser84415963paus_er
percher143313423percher
pisher114317753_pisher
plasher124215033plasher
plusher124010383plusher
posher115018163_posher
purser85020473purs_er
pursier94012753pursier
pursuer9338893pursuer
pusher114318283_pusher
quasher19198623quasher
qurshes19228573qurshes
raiser66620103rais_er
rancher123013633rancher
rarer54731703rar__er
raser55633413ra_s_er
rashers104020903ra_shers
rashes95330153ra_shes
rasper83917323ra_sper
raster64731443ra_ster
rather94319733ra_ther
ravisher1465453ravisher
rusher94019653_rusher
sarkier113413313sarkier
sarsar63011843sars_ar
sarsen6314233sars_en
sarsnet7314813sarsnet
sashed105622943sa_shed
sashes94728483sa_shes
sassier73413233sassier
searcher13209103searcher
sharer95025483shar__er
sharker144313813shar_ker
sharper124312703shar_per
shusher13288113shusher
slasher104515323slasher
smasher123911013smasher
sparser94311483spars_er
swasher134011503swasher
swisher13369523swisher
tapster9299273tapster
tardier859719993tardier
tarrier74323173tarrier
tarsiers8298533tarsiers
tarter64023563tar_ter
tartier74123263tartier
taster64930573ta_ster
terser67317823ters_er
thatcher1635653thatcher
thirster1135673thirster
thrashed1555363thrashed
thrashers1565293thrashers
thrashes1487653thrashes
thresher1455823thresher
trashed113514693trashed
trashers113013623trashers
trashes104119253trashes
trashier113210093trashier
usher84517763__usher
vanisher14167453vanisher
varier94619353var_ier
varnisher15195403varnisher
vaster94521023va_ster
verser94516963vers_er
waister103812383waister
warbler123211463warbler
warder104020273war_der
warier93722893war_ier
warmer113816733war_mer
warner93717223war_ner
warper114015583war_per
warship1547833warship
warsle93112923warsle_
warsled112910443warsled
warslers11328073warslers
warsles103413643warsles
warstler11275933warstler
wartier103413913wartier
washed135521503wa_shed
washers134517523wa_shers
washes124425493wa_shes
washier133611153wa_shier
waster95228943wa_ster
watcher153113403watcher
welsher13377443welsher
wisher123617063_wisher
worser95117523wors_er
yarder103813973yar_der
yarer84321573yar__er
yarner93313063yar_ner

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.1561145455.1
2DLD Change Limit1340274847.50017870.3
3Display Results4844840.1732797.7
 (SQL Overall)1786914847.82922824.2
 
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.