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

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

287 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
system113574(None) 
systems1234681systems
oyster94111702oyster
satem76021462s_atem
sestet6826202sestet
shyster13116562shyster
sister64421582sister
stem610628252__stem
systemic1545932systemic
xyster16366802xyster
aster55434893_aster
baste74829983baste_
basted95227233basted
baster85333593baster
bastes85330383bastes
beseem1069083beseem
bested94922753bested
bister84922763bister
busted95123153busted
buster84726493buster
byte96521813by_te_
bytes105217493by_tes
caste75932363caste_
caster85232573caster
castes85631863castes
cisted95217523cisted
clyster12317453clyster
costed95623113costed
coster84331293coster
custom104010273custom
cyst96322813cyst__
cystein1246053cystein
cystic132710653cystic
cysts105912773cyst_s
diastem10318043diastem
dusted83918373dusted
duster74919723duster
easter65027983easter
ecosystem1671423ecosystem
esteem838813_esteem
ester54727713_ester
fasted105320953fasted
fasten95114893fasten
faster94625773faster
fester94723513fester
fisted104218703fisted
foster94322223foster
fytte1138583fytte_
fyttes1236933fyttes
gasted84821583gasted
gaster75027353gaster
geste65920693geste_
gestes75721393gestes
gusted84316723gusted
gypster1333953gypster
haste85927863haste_
hasted105125283hasted
hasten95718563hasten
hastes95727073hastes
histed104420243histed
hosted105020343hosted
hostel93914153hostel
hyte109018943hy_te_
instep838193instep
item65620383__item
jested144416503jested
jester134319153jester
justed144215773justed
juster134617013juster
keyster14256153keyster
kyte117017763ky_te_
kytes125012913ky_tes
lasted74323603lasted
laster64830633laster
listed74322833listed
listee64223063listee
listel64214743listel
listen64816813listen
lister64527253lister
lusted74319443lusted
luster64023673luster
lysate9388103lysate_
lysates10317473lysates
lyse76320593lys_e_
lysed95011563lys_ed
lyses84518253lys_es
masted94025803masted
master84831343master
mestee84523883mestee
misted93625823misted
mister84728563mister
misterm114314513misterm
moste75925083moste_
musted93321073musted
mustee83922103mustee
muster84724523muster
mystery15436523mystery
mystic132711643mystic
nested74720063nested
nester64124183nester
nonsystem1452633nonsystem
ousted73720583ousted
ouster64223733ouster
oysters103411693oysters
paste74932953paste_
pasted94426903pasted
pastel85918713pastel
paster85734373paster
pastes85233913pastes
pester84827593pester
piste75824603piste_
pistes85325633pistes
posted93722493posted
poster84129173poster
raster64731443raster
rested74430783rested
rester63832433rester
retem74221953_retem
roster64329083roster
royster103110533royster
rusted75020923rusted
sachem134012223sachem
salted74121203salted
salter64325083salter
sashed105622943sashed
sashes94728483sashes
sassed76116173sassed
sasses64124393sasses
sate45556103s_ate_
sated66238533s_ated
sates54949323s_ates
saute55028083saute_
sauted74119603sauted
sautes63924913sautes
sayst85322003sayst__
scoter83815483scoter
scute75520943scute_
scutes85219193scutes
scutum1036373scutum
seated75131053seated
seater64534153seater
seem65438563__seem
sente56432873sente_
septet8921133septet
septum1038003septum
sesame8311013sesame
sestets7911473sestets
settee63721023settee
setter64023723setter
sextet13916873sextet
shote85526103shote_
shotes95321913shotes
shute84520353shute_
shuted103913173shuted
shutes93518223shutes
shysters14106463shysters
sifted104313673sifted
sifter94516233sifter
silted74020013silted
sinter63625923sinter
sises55233833sis_es
sisses64520603sisses
sisters73721593sisters
sistra639333sistra
sistrum946563sistrum
site47052413s_ite_
sited65130743s_ited
sites56045433s_ites
sitten64113823sitten
sitter63323383sitter
sixte126216583sixte_
sixtes133612403sixtes
skate94721553skate_
skated114414883skated
skater105015493skater
skates104219403skates
skite95120053skite_
skited114313483skited
skites104418043skites
slate55438283slate_
slated75028313slated
slater64429183slater
slates64934063slates
slatey95417063slatey
smite75224873smite_
smiter83616413smiter
smites83921923smites
smote75820283smote_
soften9429493soften
softer94015313softer
sooted73922593sooted
sorted74523713sorted
sorter64425093sorter
sotted74121403sotted
souter64225923souter
spate74731583spate_
spates85028173spates
spirem104214163spirem
spite75430663spite_
spited94820443spited
spites84127333spites
sputum1035943sputum
state56237333state_
stated75427833stated
stater64427563stater
states64337083states
steam76322933__steam
stems75219953__stems
step67126293__step
stet45947323__stet
stew77525463__stew
stey76224413__stey
stum65526023__stum
subitem1138553subitem
subsystem1652393subsystem
suite54829563suite_
suited74019423suited
suiter64121813suiter
suites63727403suites
sussed75015533sussed
susses64221053susses
suttee63721543suttee
syboes1139343syboes
syce95820283sy_ce_
sycee105018623sy_cee
sycees11409653sycees
syces106416463sy_ces
syke115420563sy_ke_
sykes124816863sy_kes
symptom1644003symptom
synced12266963synced
syncom1336093syncom
syndet10311963syndet
syne75725763sy_ne_
syntagm1343313syntagm
syntax1634303syntax
synth113711823synt_h
synths12377883synths
sypher14317083sypher
syren85216743sy_ren
sysop1037193sys_op
sysops1136013sysops
systemics1644273systemics
systemize2344763systemize
systole1035763systole
systoles1146483systoles
taste55127233taste_
tasted74123973tasted
taster64930573taster
tastes64126423tastes
tested74421523tested
testee64323303testee
tester64227153tester
testes65125823testes
totem74819373_totem
tryste9399583tryste_
trysted11428273trysted
tryster10369513tryster
trystes10419993trystes
ulster63712103ulster
unstep839223unstep
upstep1035503upstep
vaster94521023vaster
vested104217353vested
vestee94319153vestee
waste86125053waste_
wasted104423023wasted
waster95228943waster
wastes96224883wastes
wester94222893wester
wisted104120273wisted
wyte106018643wy_te_
wyted12529473wy_ted
wytes114113433wy_tes
xylem1736123xy_lem
xyst144714073xyst__
xysters17307163xysters
xysti15538153xyst_i
xystoi16365133xystoi
xystos16356913xystos
xysts15558123xyst_s
xystus16354423xystus
yester93417983yester
ylem9217893_y_lem
zested164214043zested
zester153617793zester
zoster153715853zoster

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127162874.67324120.7
3Display Results2872870.0933086.0
 (SQL Overall)1786912875.12634859.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.