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

179 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
systems123468(None) 
system1135741system_
oysters103411692oysters
sestets7911472sestets
shysters14106462shysters
sisters73721592sisters
stems75219952__stems
systemic1545932systemic
systemics1644272systemics
xysters17307162xysters
asters65631603_asters
basters94930303basters
bastes85330383baste_s
beseems1175913beseems
bisters93922613bisters
busters94724133busters
bytes105217493by_te_s
casters94729903casters
castes85631863caste_s
clysters13227843clysters
costers94128333costers
customs11348263customs
cystein1246053cystein
cysteins1355733cysteins
cysts105912773cyst__s
diastems11226523diastems
dusters84918363dusters
easters75125683easters
ecosystems1771053ecosystems
esteems935243_esteems
esters64627733_esters
fastens105511753fastens
festers104121393festers
fosters104220103fosters
fyttes1236933fytte_s
gasters85624293gasters
gestes75721393geste_s
gypsters1434023gypsters
hastens106214813hastens
hastes95727073haste_s
hostels103712313hostels
hostess103210243hostess
insteps936573insteps
items7499613__items
jesters144118193jesters
justers143815733justers
keysters15326333keysters
kytes125012913ky_te_s
lasters75627693lasters
listees73416673listees
listels74212433listels
listens74014133listens
listers74026533listers
lusters73921443lusters
lysates10317473lysate_s
lyses84518253lys_e_s
masters94628923masters
meseems1165603meseems
mestees94617753mestees
misterms123711353misterms
misters93927513misters
mustees94614923mustees
musters94522513musters
mystery15436523mystery
mystics14279103mystics
nesters74422793nesters
nonsystems1552183nonsystems
ousters74122793ousters
oyster94111703oyste_r
pastels95215183pastels
pasters94531733pasters
pastes85233913paste_s
pesters93827093pesters
pistes85325633piste_s
posters93928013posters
rasters74629023rasters
resters74130403resters
retems83914573_retems
rosters73727543rosters
roysters113610533roysters
sachems14348903sachems
salters73622253salters
santims9312603santims
sashes94728483sashe_s
sasses64124393sasse_s
satem76021463s_atem_
sates54949323s_ate_s
sautes63924913saute_s
scoters93313813scoters
scutes85219193scute_s
seaters74028943seaters
seems75525023__seems
septets998953septets
septums1135743septums
sesames9310743sesames
sestet6826203seste_t
settees73513633settees
setters73822063setters
sextets1497143sextets
shotes95321913shote_s
shutes93518223shute_s
shyster13116563shyste_r
sifters103714793sifters
sinters74024083sinters
sises55233833sis_e_s
sisses64520603sisse_s
sister64421583siste_r
sistrums1055313sistrums
sites56045433s_ite_s
sitters74221553sitters
sixtes133612403sixte_s
skaters113512963skaters
skates104219403skate_s
skites104418043skite_s
slaters73123733slaters
slates64934063slate_s
smiters93414363smiters
smites83921923smite_s
softens10347623softens
sorters74221133sorters
souters74422603souters
spates85028173spate_s
spirems11499563spirems
spites84127333spite_s
staters73922343staters
states64337083state_s
steams84916903__steams
stem610628253__stem_
steps76619883__steps
stets55423913__stets
stews85519143__stews
stums75320083__stums
subitems1245493subitems
subsystems1751833subsystems
suiters73618883suiters
suites63727403suite_s
susses64221053susse_s
suttees74114063suttees
syboes1139343syboe_s
sycees11409653sy_cees
syces106416463sy_ce_s
sykes124816863sy_ke_s
symptoms1743763symptoms
syncoms1435943syncoms
syndets1136113syndets
syntagms1442723syntagms
synths12377883synt_hs
syphers15317273syphers
syrens94911993sy_rens
sysops1136013sys_ops
systemize2344763systemize
systemizes2444633systemizes
systemless1541993systemless
systole1035763systole
systoles1146483systoles
tasters74225643tasters
tastes64126423taste_s
testees74215913testees
testers74124543testers
testes65125823teste_s
totems86810763_totems
trysters11298373trysters
trystes10419993tryste_s
ulsters72711983ulsters
unsteps936213unsteps
upsteps1133743upsteps
vestees103513173vestees
wasters104026593wasters
wastes96224883waste_s
westers105221963westers
wytes114113433wy_te_s
xylems1833203xy_lems
xyster16366803xyste_r
xystos16356913xyst_os
xysts15558123xyst__s
xystus16354423xyst_us
ylems1039263_y_lems
zesters163517293zesters
zosters163015413zosters

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271796.20321606.8
3Display Results1791790.0632841.3
 (SQL Overall)1786911796.67226782.2
 
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.