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

170 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
selle5442831(None) 
belle75827831belle
sell45840611sell_
seller63824591seller
selles64426981selles
sells55134431sells
belie75630382belie
bell66237182bell_
belled94626182belled
belles85325992belles
bells76432162bells
belly104625492belly
cell65031722cell_
cella75420312cella
cellae84915932cellae
celled94420322celled
celli76717692celli
cello74919582cello
cells75428062cells
dele56843082de_le
dell56938202dell_
dells66630942dells
delly96023872delly
delve96018262delve
ell36735682_ell_
ells46431352_ells
else45923082_else
fell76833072fell_
fella84918652fella
felled103720302felled
feller94419552feller
felloe93513922felloe
fells85327382fells
felly114922802felly
fille84327402fille
gelee63626982gelee
gelled84718892gelled
hell75637892hell_
helled104024702helled
heller93322512heller
hello86522982hello
hells85032042hells
helve115018092helve
jell117125872jell_
jelled144916062jelled
jello126716272jello
jells125522162jells
jelly154218252jelly
kelly124617022kelly
melee73729102melee
mell64935612mell_
melled95023022melled
mells75031332mells
merle75824372merle
mille75029132mille
nellie63614812nellie
nelly84618812nelly
pele65539552pe_le
pellet83326552pellet
rille55728732rille
roselle7310242roselle
sable74732162sable
sale44959702s_ale
sall44544682sall_
sallet63734542sallet
sally85129712sally
salve85022132salve
scale74629142scale
seal45654372seal_
sealed74328362sealed
sealer63928962sealer
seals54839692seals
sedge75019952sedge
sedile73517232sedile
see35772262se__e
seel45042982seel_
seeled73922092seeled
seels55632822seels
seely84522632seely
segue6314412segue
seine55732872seine
seise54727852seise
seize143819502seize
sel38253322se_l_
selah8319612selah
self75138292se_lf
selfed10310912selfed
selfs85220242selfs
selkie102811692selkie
sellers73721302sellers
sels46345982se_ls
selva83014272selva
selves94119612selves
seme65836652se_me
semple103212752semple
sene46848052se_ne
senile63420212senile
sense55526822sense
sente56432872sente
sere46153472se_re
serge64727462serge
serve85425962serve
setae56026222setae
settle63915662settle
shale85332832shale
shell84424122shell_
shelled113815082shelled
sheller103515882sheller
shells94319522shells
shelly124414462shelly
shelve124012762shelve
sidle65124032sidle
sill45545152sill_
siller64026052siller
sills55135982sills
silly84527612silly
skell94915832skell_
skells105013782skells
sloe45534952s_loe
slue45332192s_lue
smell74916232smell_
smelled103511852smelled
smeller94212782smeller
smells83914742smells
smelly114110352smelly
smile74823912smile
snell54517302snell_
snelled83313042snelled
sneller73512842sneller
snells64614202snells
socle7419572socle
sole46053672s_ole
solve85618942solve
spale74929212spale
spell75020302spell_
spelled103714732spelled
speller95415142speller
spells84617682spells
spile75230082spile
stale55637102stale
stelae63716482stelae
stele55026842stele
stella63612972stella
stile54931572stile
stole54928812stole
style85519362style
sullen62914292sullen
sully84622892sully
svelte9319752svelte
swale85221592swale
swell84815982swell_
swelled113211692swelled
sweller103012462sweller
swells93913982swells
telae54323292telae
tele45040872te_le
tell44934702tell_
teller63519812teller
tells55828942tells
telly84920822telly
tulle54019932tulle
well75832042well_
welled103820212welled
wellie92814912wellie
wells85426192wells
welly114620012welly
yell76028322yell_
yelled104116252yelled
yeller94214512yeller
yells85821942yells

Search took 3 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 Filter178691538000.1101624463.6
2DLD Change Limit538001702.62620487.4
3Display Results1701700.1101545.5
 (SQL Overall)1786911702.84662786.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.