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

173 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
else4592308(None) 
ease45042331ease
els37645721els_
alae45643752alae
ale36572342al_e
alee46652322alee
ales47067102ales
alme65832162alme
aloe45540192aloe
als36663022als_
also46423442also
apse67725382apse
arse46539272arse
base64847022base
belie75630382belie
belle75827832belle
bels66142492bels_
bise66437092bise
blae66134642blae
blase75524232blase
blue65328462blue
case65848082case
cease75227652cease
cels65534972cels_
cense75121402cense
close76425222close
clue65324532clue
dele56843082del_e
deles65139252deles
dels56745472dels_
delve96018262delve
dense65923502dense
dose56442432dose
dulse65415042dulse
eased65430402eased
easel54521112easel
eases56041612eases
east46659102east
easy76224492easy
eave75733582eave
eche97520282eche
edge65719662edge
eds46638922eds_
eels46536742eels_
efs66829602efs_
eide55832232eide
eke75630092e_ke
ekes86726602ekes
el26745292el__
elan46734242elan
elapse857522elapse
elate55335882elate
eld46733792el_d
elder64020022elder
elds56324852elds
elf66138522el_f
elhi7612402elhi
elide64922642elide
elite56230182elite
elk76726122el_k
elks85820032elks
ell36735682el_l
ells46431352ells
elm57531742el_m
elms67322702elms
elmy95616792elmy
elope75219342elope
elude64517622elude
elute54822572elute
elver85216242elver
elves85118742elves
eme55837182e_me
emes65434662emes
ems56435492ems_
ens37245922ens_
ensue54013832ensue
epee64628502epee
erase54925492erase
ere36352772e_re
erne46727422erne
erose55727272erose
ers36046282ers_
erses55826802erses
erst47436432erst
es29048222e_s_
eses45336102e_ses
esne47018792esne
ess36030882e_ss
esses56422972esses
eve66331162e_ve
eves76230462eves
evulse935212evulse
ewe66630982e_we
ewes76328702ewes
exes116530812exes
eye65539772e_ye
eyes75837882eyes
eyne76322462eyne
eyre75525252eyre
false84818122false
fease84824872fease
fesse86116332fesse
flee76238792flee
floe76129772floe
flue75329852flue
fuse76429992fuse
geese64316002geese
gelee63626982gelee
gels56836102gels_
glee55239062glee
glue55628492glue
helve115018092helve
hose76547242hose
isle45121702isle
jesse126012832jesse
lase46148512lase
lease55230262lease
lee36068142_lee
lees45455882lees
leke85527402leke
lense54523432lense
les35663072les_
leses54930812leses
less45635102less
lest46956322lest
lie38264522_lie
lose45144582lose
lye66533412_lye
lyse76320592lyse
melee73729102melee
mels65941532mels_
mense75025632mense
mise66043572mise
muse67136032muse
nose46739362nose
ole37155212ol_e
oles46453472oles
ose38147342_ose
owse76321622owse
pase65346862pase
pease75231112pease
peise75825772peise
pele65539552pel_e
peles75738082peles
perse75429522perse
plie65127392plie
pose66441732pose
pulse74219972pulse
rase46149982rase
reuse56025362reuse
rise45945232rise
rose46148902rose
ruse45938932ruse
seise54727852seise
selle54428312selle
sels46345982sels_
sense55526822sense
sloe45534952sloe
slue45332192slue
tease55428712tease
telae54323292telae
tele45040872tel_e
teles54536002teles
tels46841692tels_
tense55225842tense
terse55026822terse
use36835162_use
valse85117522valse
vase75629652vase
verse84723582verse
vise75632672vise
welsh113110362welsh
wise75737342wise

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.0632836365.1
2DLD Change Limit298721731.07627762.1
3Display Results1731730.0802162.5
 (SQL Overall)1786911731.219146588.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.