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

226 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
xystos1635691(None) 
xystoi16365131xystoi
xysts15558121xyst_s
xystus16354421xystus
cestos84718092cestos
custos84014312custos
cysts105912772cyst_s
pestos84719082pestos
xyst144714072xyst__
xyster16366802xyster
xysters17307162xysters
xysti15538152xyst_i
altos55822953_altos
aristos7312373aristos
askos95011773_askos
autos56523323_autos
bassos85313703bassos
bastes85330383bastes
basts75936933bast_s
bentos86218303bentos
besots86415453besots
bestow1149463bestow
bestows1248863bestows
bests75932613best_s
bistros92810983bistros
boston8513043boston
bostons9312903bostons
busts75227693bust_s
byssus1133763byssus
bytes105217493by_tes
cantos84826973cantos
castes85631863castes
castor84418533castor
castors94919443castors
casts77237793cast_s
centos85920463centos
cestas85018543cestas
cestoi84511953cestoi
cestus84412913cestus
ciscos104711133ciscos
cists76624533cist_s
cistus84611343cistus
contos84923233contos
cosmos10311753cosmos
costs77231143cost_s
cryptos14337213cryptos
cussos84210003cussos
custom104010273custom
customs11348263customs
cyclos1338073cyclos
cyst96322813cyst__
cystic132710653cystic
cystoid13309213cystoid
cystoids14306743cystoids
cyton101511463cy_ton
cytons111710183cy_tons
datos65222783_datos
dattos74311903dattos
discos94915213discos
dittos74111973dittos
dusts65923563dust_s
easts57530323east_s
estop74312103_estop
estops84011223_estops
exists134710913exist_s
fasts86429683fast_s
fatsos9389423fatsos
fests85828043fest_s
fists85527543fist_s
fynbos1433283fynbos
fyttes1236933fyttes
gasts66628633gast_s
gestes75721393gestes
gests66028813gest_s
gismos957183gismos
gists66026193gist_s
gusto65414643gusto_
gustoes879873gustoes
gusts65722793gust_s
gyros95616483gy_ros
hastes95727073hastes
hests85829933hest_s
hists86328373hist_s
hostas94515833hostas
hosts85526703host_s
hydros13279363hydros
hypos1312014743hy_pos
hyson1138693hys_on
hysons1237633hysons
hyssop1443413hyssop
hyssops1543123hyssops
jatos125116823_jatos
jests125922453jest_s
juntos134110843juntos
justs124918263just_s
kists95822113kist_s
kotos95717703_kotos
kussos10336423kussos
kyats125012443kyat_s
kytes125012913ky_tes
lassos64913813lassos
lasts57731263last_s
lentos65317403lentos
lesbos837403lesbos
lists56628693list_s
lotos54724633_lotos
lottos64613103lottos
lusts55022803lust_s
lysates10317473lysates
lyses84518253lys_es
lysins94610953lysins
lysis84511463lys_is
lyssas935443lyssas
lyttas985073lyttas
masts77035763mast_s
misos76523293mis_os
mists76633903mist_s
mosts76028543most_s
mottos84615243mottos
musths11589483musths
musts75527443must_s
mysids1246563mysids
mysost1138263mys_ost
mystic132711643mystic
mystics14279103mystics
mythos14398473mythos
myths135911603my_ths
nestor63713423nestor
nestors73614973nestors
nests55728003nest_s
nostoc868193nostoc
nostocs947553nostocs
oasts56529183oast_s
ottos54714323_ottos
ousts55225703oust_s
oyster94111703oyster
oysters103411693oysters
pantos85222743pantos
paseos88015813paseos
pastas85422873pastas
pastes85233913pastes
pastis84924323pastis
pastor84817483pastor
pastors94119003pastors
pasts75936503past_s
pesos77221623pes_os
pesto75723723pesto_
pests75933273pest_s
photos113316643photos
pintos86021293pintos
piscos105112593piscos
pisos76021063pis_os
pistes85325633pistes
pistol83313333pistol
pistols93213983pistols
piston83515923piston
pistons93016373pistons
pistou83211843pistou
pistous92714383pistous
postop10511943postop
postops11311713postops
posts75228783post_s
pottos84615873pottos
prestos93716083prestos
puntos85915793puntos
pyros105718293py_ros
ratos55528763_ratos
rectos85718783rectos
rests54935873rest_s
rotos56027883_rotos
rusts55026993rust_s
ryots85313783ryot_s
santos64421833santos
sextos134012163sextos
sos37761603__s_os
sots45552453__sots
stoa45425913__stoa
stoas55126023__stoas
stob66724613__stob
stobs75718233__stobs
stop66532033__stop
stops74827283__stops
stoss54316343__stoss
stot46347333__stot
stots54828553__stots
stow77325743__stow
stows86622703__stows
synths12377883synths
sysop1037193sys_op
sysops1136013sysops
system1135743system
systems1234683systems
systole1035763systole
systoles1146483systoles
tastes64126423tastes
testes65125823testes
testis64916713testis
teston6313303teston
testons7313563testons
tests56530193test_s
trystes10419993trystes
trysts9448793tryst_s
typos106015813ty_pos
tyros85118593ty_ros
unstop837473unstop
unstops936993unstops
vasts86423773vast_s
vestas95916683vestas
vests85325983vest_s
vistas94513273vistas
wastes96224883wastes
wasts87433673wast_s
wests85727003west_s
wists86728523wist_s
wytes114113433wy_tes
xylans1635883xylans
xylems1833203xylems
xylitol1742023xylitol
xylitols1841753xylitols
xylol1546133xy_lol
xylols1634173xylols
xylose1636763xy_lose
xylyls1931833xylyls
yetis85418393_yetis
yetts86715133_yetts
zests145419743zest_s

Search took 10 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.763234195.3
2DLD Change Limit1127162268.44013355.0
3Display Results2262260.0762973.7
 (SQL Overall)1786912269.27919257.6
 
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.