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 “hern” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

243 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
hern7613489(None) 
ern35738351_ern
fern76129321fern
hen67555271he_n
her66547811her_
herb94730961herb
herd84933061herd
here76447101here
herl75834551herl
herm95636151herm
herns84825581herns
hero74635781hero
heron85025501heron
hers75844871hers
hewn106719851hewn
horn76735611horn
kern85326211kern
tern46134801tern
aeon45634612aeon
aero45435342aero
aery77231682aery
airn46433832airn
barn66444642barn
bean66443862bean
been65335782been
ben56554922be_n
berg75425542berg
berk105929842berk
berm86732752berm
born67338412born
bren65629562bren
burn65636422burn
carn66245432carn
cere66741472cere
cero66329452cero
chert105232102chert
churn105113102churn
corn69945812corn
curn66731882curn
darn56434622darn
dean56039482dean
den47554342de_n
dere56845902dere
derm76031892derm
durn56127622durn
earn46737552earn
eery76129622eery
en28052392_e_n
eon36052082_eon
er28345142_er_
era35741502_era
ere36352772_ere
erg45531072_erg
erne46727422_erne
erns45428222_erns
err35626532_err
ers36046282_ers
fen66851352fe_n
fer66646122fer_
fere76342232fere
ferns85220082ferns
ferny115816182ferny
firn76927502firn
gen45950512ge_n
germ75428962germ
girn56026862girn
haen76229452haen
hard85443502hard
hare76255732hare
hark115237392hark
harl75740002harl
harm95637792harm
harp96134282harp
hart76865772hart
he58151952he__
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heard95222752heard
hears86737372hears
heart85440742heart
heat77061422heat
hebe96424702hebe
heck135826492heck
heed86437602heed
heel75034222heel
heft106736292heft
heh96039622he_h
hehs106723962hehs
heil76328932heil
heir77523802heir
heirs85618562heirs
held85330402held
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
hem86148732he_m
heme95034412heme
hemin103620932hemin
hemp115725622hemp
hems95534942hems
henna84414042henna
henry114014472henry
hens75642572hens
hent76656382hent
hep86644142he_p
herbs105520502herbs
herby134715312herby
herds96424682herds
herein93717792herein
hereon93914362hereon
heres86245902heres
herls85226432herls
herma105318882herma
herms105626432herms
hernia9312292hernia
heroin94420592heroin
herons94820542herons
heros84930862heros
herry114922472herry
hertz174919032hertz
hes66654202he_s
hest75950772hest
het67674312he_t
heth107028022heth
hets75547202hets
hew97642722he_w
hews105631572hews
hex137436172he_x
hey96741062he_y
hin67559562h_in
hire75538962hire
hisn79620932hisn
hoer76533982hoer_
hoers85724922hoers
hon67759382h_on
hora76136552hora
horns86125332horns
horny115619622horny
hun65844712h_un
hurl76029932hurl
hurt77142572hurt
hwan105716892hwan
hymn12311312hymn
jean116629282jean
jeon116821442jeon
jerk154920132jerk
karn86129412karn
keen84830402keen
ken76343982ke_n
kerb104322712kerb
kerf115827462kerf
kerne94718212kerne
kerns94719562kerns
kirn87123432kirn
lean46345242lean
learn55322662learn
lorn46435252lorn
mean65538082mean
men59252842me_n
merc87225622merc
mere67244442mere
merk106027942merk
merl65830972merl
morn66237562morn
neon47026422neon
nerd56624942nerd
pean66147172pean
peen65938082peen
pein65834942pein
pen56558842pe_n
peon65635242peon
per56353092per_
pere66450262pere
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
pert66759322pert
perv97224812perv
pirn67128372pirn
porn65636022porn
quern143610402quern
rein46040892rein
reran57329102reran
rerun58722152rerun
seen46943122seen
sen36058522se_n
ser36752402ser_
sera46141392sera
sere46153472sere
serf76340112serf
serin55434442serin
sers45746652sers
sewn76124332sewn
sharn84823702sharn
sheen85023312sheen
sherd96321152sherd
shewn115715702shewn
shorn85722172shorn
sorn46641062sorn
stern55319122stern
tarn46842722tarn
teen45938202teen
ten35856112te_n
term66233152term
terne56426152terne
terns55226872terns
thegn95810902thegn
thein85919022thein
then78429692the_n
there87527392there
therm106018022therm
thorn85318702thorn
torn46044252torn
turn46330382turn
urn35731462_urn
vein75625752vein
vera76828842vera
verb96224872verb
vert77249372vert
very108025642very
warn75239322warn
wean75734352wean
ween75835462ween
wen66249602we_n
were76238332were
wert79749822wert
wheen115016052wheen
when105723042whe_n
where117019422where
worn75631752worn
wren78221682wren
yarn75230042yarn
yean75834582yean
yearn86316432yearn
yen66847382ye_n
yerk116222082yerk
zein135620602zein
zerk175319252zerk
zero134822462zero

Search took 2 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 Filter178691298720.0762351197.4
2DLD Change Limit298722431.45320558.8
3Display Results2432430.0465282.6
 (SQL Overall)1786912431.575113454.6
 
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.