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

202 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
erne4672742(None) 
ere36352771er_e
ern35738351ern_
ernes55224811ernes
erns45428221erns
esne47018791esne
eyne76322461eyne
kerne94718211kerne
terne56426151terne
acne66625872acne
aerie54634602aerie
ane37866942_ane
are37874572ar_e
arene55329412arene
arse46539272arse
bane65250422bane
bene66439492bene
benne76521122benne
berme96022942berme
bine66650852bine
bone65949322bone
borne77926792borne
brae65639112brae
bree67241262bree
bren65629562bren
brie65837902brie
brine75132272brine
cane66653112cane
cere66741472cer_e
cine66242942cine
cone67256962cone
crane75331602crane
crone75231332crone
dene56643412dene
dere56845902der_e
dine55555332dine
done55747912done
dree56638322dree
drone65324982drone
dune56137582dune
dyne85320932dyne
earn46737552earn_
earned74818332earned
earner63617222earner
earns55927562earns
ease45042332ease
eave75733582eave
eche97520282eche
edge65719662edge
eerie55228532eerie
eide55832232eide
eke75630092e_ke
else45923082else
eme55837182e_me
en28052392e_n_
end46834352e_nd
eng46726782e_ng
ens37245922e_ns
eon36052082eon_
eons46638712eons
epee64628502epee
er28345142er__
era35741502er_a
eras45441502eras
erase54925492erase
erg45531072er_g
ergo56420152ergo
ergs55523812ergs
ermine8416922ermine
erode64520992erode
eros45238452eros
erose55727272erose
err35626532er_r
erred65915672erred
errs45622532errs
ers36046282er_s
erses55826802erses
erst47436432erst
esnes54817362esnes
eterne6311722eterne
etna46415262etna
eve66331162e_ve
even75222272even
ewe66630982e_we
exine125518492exine
eye65539772e_ye
eyen76223662eyen
eyre75525252eyre
eyrie88117832eyrie
fane75343562fane
fere76342232fer_e
ferine96422582ferine
fern76129322fern_
ferns85220082ferns
ferny115816182ferny
fine75147952fine
frae75330472frae
free75940182free
froe75329992froe
gane55145292gane
gene56237222gene
genre66016802genre
gone55639042gone
gree56641562gree
grue55825712grue
here76447102her_e
hern76134892hern_
herns84825582herns
hone77549322hone
ire36943172ir_e
irone55126362irone
jane115031472jane
kane85133962kane
kern85326212kern_
kerned114112922kerned
kernel104010582kernel
kernes104717522kernes
kerns94719562kerns
kine85643422kine
krone94018732krone
kune85424572kune
lane45153322lane
leone55018822leone
lierne638022lierne
line46965572line
lone45849132lone
lune47140492lune
mane65052012mane
merde84320122merde
mere67244442mer_e
merge84523682merge
merle75824372merle
mesne75116292mesne
mine67256152mine
ne27045102__ne
nene45932062nene
nerve86617372nerve
nine45842172nine
none45743172none
one37050912_one
ore36661832or_e
orle45630462orle
pane64950282pane
penne75423852penne
pere66450262per_e
perse75429522perse
pine67755712pine
pone65747532pone
pree67044732pree
prone75332622prone
prune75119632prune
re26153742_r_e
rede55037662rede
ree37974072_ree
rend56136572rend
renew83917512renew
rent46661242rent
rente54733782rente
rete44944132rete
roe36861072_roe
rue35549262_rue
rune45236292rune
rye66032542_rye
sane45954332sane
seine55732872seine
sene46848052sene
sere46153472ser_e
serene63522352serene
serge64727462serge
serine65432672serine
serve85425962serve
sine46560622sine
sone46649982sone
syne75725762syne
terce75721842terce
tern46134802tern_
ternes65422902ternes
terns55226872terns
terse55026822terse
tine45855132tine
tone46953742tone
tree47745812tree
trine54734602trine
trone55131862trone
true46725852true
tune45635862tune
tyne76325052tyne
urge54722412urge
urine55026592urine
urn35731462urn_
urns46323892urns
vane75534682vane
verge93419832verge
verse84723582verse
verve115417722verve
vine75643682vine
wane76344712wane
were76238332wer_e
wine74953422wine
wren78221682wren
zine137036152zine
zone135231082zone

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.0802233637.5
2DLD Change Limit298722021.03029001.9
3Display Results2022020.0633206.3
 (SQL Overall)1786912021.173152336.7
 
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.