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

369 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
here7644710(None) 
cere66741471cere
dere56845901dere
ere36352771_ere
fere76342231fere
hare76255731hare
hebe96424701hebe
heme95034411heme
her66547811her_
herb94730961herb
herd84933061herd
heres86245901heres
herl75834551herl
herm95636151herm
hern76134891hern
hero74635781hero
hers75844871hers
hire75538961hire
mere67244441mere
pere66450261pere
sere46153471sere
there87527391there
were76238331were
where117019421where
acre67330772acre
adhere10310332adhere
aerie54634602aerie
aero45435342aero
aery77231682aery
are37874572_are
bare65460522bare
bee56262402be_e
beer65635992beer
bene66439492bene
beret74946362beret
berg75425542berg
berk105929842berk
berm86732752berm
berme96022942berme
bore66051332bore
bree67241262bree
byre95023852byre
care66968372care
cede74928762cede
cee55952702ce_e
cepe84926652cepe
cered85227442cered
ceres75540012ceres
cero66329452cero
cete64934782cete
chare105231982chare
cheer105420382cheer
chert105232102chert
chevre14318312chevre
chore105126762chore
cire65836372cire
cohere112716992cohere
core67263112core
cure66149122cure
dare55848862dare
dee47665822de_e
deer56739022deer
deke95228762deke
dele56843082dele
deme76536282deme
dene56643412dene
derm76031892derm
dire56644142dire
dore56353302dore
dree56638322dree
dure56341812dure
eerie55228532eerie
eery76129622eery
eke75630092_eke
eme55837182_eme
er28345142_er_
era35741502_era
erg45531072_erg
ern35738352_ern
erne46727422_erne
err35626532_err
ers36046282_ers
eve66331162_eve
ewe66630982_ewe
eye65539772_eye
eyre75525252eyre
fare76354462fare
fee66862012fe_e
feme96130542feme
fer66646122fer_
feres86038182feres
fern76129322fern
fete75734922fete
fire76245592fire
fore78351472fore
free75940182free
frere85617722frere
gee45359202ge_e
gene56237222gene
genre66016802genre
germ75428962germ
ghee85726112ghe_e
gore55744962gore
gree56641562gree
gyre84722762gyre
hade85440192hade
hae67364002h_ae
haeres94017032haeres
hake115637842hake
hale76052832hale
hame97043132hame
hard85443502hard
hared95742182hared
harem104924452harem
hares86255542hares
hark115237392hark
harl75740002harl
harm95637792harm
harp96134282harp
hart76865772hart
hate78450172hate
have106137072have
haze164833392haze
he58151952h__e
head87137172head
heal75645692heal
heap96432892heap
hear76143882hear
heard95222752heard
hearer94323642hearer
hears86737372hears
hearse94114272hearse
heart85440742heart
heat77061422heat
heave114521812heave
hebes105521672hebes
heck135826492heck
heder95623632heder
hedge105317332hedge
heed86437602heed
heel75034222heel
heeze175313482heeze
heft106736292heft
heh96039622he_h
hehs106723962hehs
heil76328932heil
heir77523802heir
heired103813042heired
heirs85618562heirs
held85330402held
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
helve115018092helve
hem86148732he_m
hemes105031082hemes
hemp115725622hemp
hems95534942hems
hen67555272he_n
hence104920042hence
henge94819822henge
henry114014472henry
hens75642572hens
hent76656382hent
hep86644142he_p
herbed123513452herbed
herbs105520502herbs
herby134715312herby
herded114215642herded
herder104516462herder
herds96424682herds
hereat93527412hereat
hereby14468332hereby
herein93717792herein
hereof123212372hereof
hereon93914362hereon
heresy125011232heresy
hereto9313692hereto
herls85226432herls
herma105318882herma
hermae115314472hermae
herms105626432herms
herns84825582herns
heroes94923822heroes
heron85025502heron
heros84930862heros
herpes115517322herpes
herry114922472herry
hertz174919032hertz
hes66654202he_s
hest75950772hest
het67674312he_t
heth107028022heth
hets75547202hets
hew97642722he_w
hewed125619432hewed
hewer115719932hewer
hewn106719852hewn
hews105631572hews
hex137436172he_x
hexed165615762hexed
hexer155116682hexer
hexes155123042hexes
hey96741062he_y
hide85134622hide
hie67652702h_ie
hike116830392hike
hired95226262hired
hiree85427802hiree
hirer85423122hirer
hires86134342hires
hive106029672hive
hoe67562722h_oe
hoer76533982hoer_
hoers85724922hoers
hoke115935932hoke
hole77553392hole
home98042442home
hone77549322hone
hope96639672hope
hora76136552hora
horde94623052horde
horn76735612horn
horse86132652horse
hose76547242hose
hove107132222hove
howe106734102howe
hue66642302h_ue
huge86321652huge
hurl76029932hurl
hurt77142572hurt
hype125519812hype
hyte109018942hyte
inhere9313712inhere
ire36943172_ire
jee106648642je_e
jeer115426462jeer
jefe146516882jefe
jerk154920132jerk
jete115927252jete
kerb104322712kerb
kerf115827462kerf
kern85326212kern
kerne94718212kerne
kore85834162kore
lee36068142le_e
leer46239352leer
leke85527402leke
lire47845292lire
lore45850352lore
lure45142462lure
lyre75623792lyre
mare64759322mare
meme85330552meme
merc87225622merc
merde84320122merde
merer75126232merer
meres75143572meres
merge84523682merge
merk106027942merk
merl65830972merl
merle75824372merle
mete64438132mete
metre74821302metre
meze154420902meze
mire66748222mire
more67154522more
mure65941332mure
nee36657782ne_e
nene45932062nene
nerd56624942nerd
nerve86617372nerve
neve76224832neve
ogre56320742ogre
ore36661832_ore
pare66760842pare
pee56066512pe_e
peer66238352peer
peke105926202peke
pele65539552pele
per56353092per_
perea75026442perea
peres76246642peres
peri65636972peri
perk106232842perk
perm85834632perm
perp89029892perp
perse75429522perse
pert66759322pert
perv97224812perv
pore66451262pore
pree67044732pree
pure65543332pure
pyre94925552pyre
rare45348432rare
re26153742__re
rede55037662rede
ree37974072re_e
rete44944132rete
rheme106214052rheme
see35772262se_e
seer45547042seer
seme65836652seme
sene46848052sene
ser36752402ser_
sera46141392sera
sered65737292sered
serer55935502serer
seres55448892seres
serf76340112serf
serge64727462serge
sers45746652sers
serve85425962serve
share86437082share
sheer84726892sheer
sherd96321152sherd
shire84727132shire
shore85432642shore
sire46150412sire
sore47059532sore
sphere113313652sphere
stere55328542stere
sure45447412sure
tare45957622tare
tee38366872te_e
tele45040872tele
terce75721842terce
term66233152term
tern46134802tern
terne56426152terne
terse55026822terse
thebe107515432thebe
thee78039062the_e
theme105921732theme
theres96525472theres
therm106018022therm
therme115814992therme
these86519012these
three87526912three
tire46143352tire
tore47359322tore
tree47745812tree
tyre75428252tyre
vee65750182ve_e
veer76229572veer
vera76828842vera
verb96224872verb
verge93419832verge
verse84723582verse
vert77249372vert
verve115417722verve
very108025642very
ware76254722ware
wee66760812we_e
weer75535092weer
wert79749822wert
whee105429592whe_e
wheres125917432wheres
wherve15568112wherve
whore116018042whore
wire75839812wire
wore77144672wore
yare75636942yare
yerk116222082yerk
yore76335942yore
zee126143232ze_e
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 Limit298723690.95331345.2
3Display Results3693690.0804612.5
 (SQL Overall)1786913691.109161128.0
 
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.