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

267 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
xysti1553815(None) 
xyst144714071xyst_
xystoi16365131xystoi
xysts15558121xysts
byssi10507992byssi
cesti75217422cesti
cyst96322812cyst_
cystic132710652cystic
cysts105912772cysts
mystic132711642mystic
xyster16366802xyster
xystos16356912xystos
xystus16354422xystus
yeti75823212_yeti
anti45536363_anti
asci66519143_asci
assai5711543assai
astir55517093_astir
ays67050293ays__
bassi77019323bassi
bast66362413bast_
baste74829983baste
basts75936933basts
best66355323best_
bestir8311163bestir
bests75932613bests
bust65947783bust_
bustic101012693bustic
busts75227693busts
busty105621013busty
bys85229463bys__
byte96521813by_te
cacti9318633cacti
cast67159903cast_
caste75932363caste
casts77237793casts
cesta75419483cesta
cestoi84511953cestoi
cist67244963cist_
cists76624533cists
coati75624633coati
cost68057943cost_
costa75523733costa
costs77231143costs
culti76317253culti
cystein1246053cystein
cystine1239333cystine
cystoid13309203cystoid
dashi95013113dashi
dhoti9310103dhoti
dhuti937523dhuti
disci85815023disci
distil73616433distil
dost57248353dost_
dust57142533dust_
dusts65923563dusts
dusty96018323dusty
east46659103east_
easts57530323easts
erst47436433erst_
exist124618943exist_
exists134710913exists
fast77052313fast_
fasts86429683fasts
fest74949443fest_
fests85828043fests
fist76248423fist_
fistic11812573fistic
fists85527543fists
fustic11910633fustic
fusty115016513fusty
fytte1138583fytte
gast56052563gast_
gasts66628633gasts
gest56149133gest_
geste65920693geste
gestic9312773gestic
gests66028813gests
gist56046763gist_
gists66026193gists
gust55240703gust_
gusto65414643gusto
gusts65722793gusts
gusty95119573gusty
gyri85415153gy_ri
hast76259483hast_
haste85927863haste
hasty115718763hasty
hest75950773hest_
hests85829933hests
hist76551543hist_
hists86328373hists
host77852833host_
hosta85917833hosta
hosts85526703hosts
hyson1138693hyson
hyte109018943hy_te
instil61111383instil
inti46626083_inti
issei568573issei
jest116738503jest_
jests125922453jests
just115433343just_
justs124918263justs
kist86540793kist_
kists95822113kists
kyat116025523kyat_
kyats125012443kyats
kyte117017763ky_te
lassi56316853lassi
last46260323last_
lasts57731263lasts
lati46438273_lati
lest46956323lest_
list47055343list_
lists56628693lists
lost47951493lost_
loti46431833_loti
lust47442603lust_
lusts55022803lusts
lusty85417573lusty
lysate9388103lysate
lyse76320593lys_e
lysed95011563lysed
lyses84518253lyses
lysin84512783lysin
lysis84511463lysis
lyssa835713lyssa
lytic104513033ly_tic
lytta888063lytta
mast65959953mast_
mastic103119173mastic
mastix152310503mastix
masts77035763masts
mayst106622673mayst_
mist66154533mist_
mists76633903mists
misty106120453misty
most66554203most_
moste75925083moste
mosts76028543mosts
mufti10610543mufti
must65145443must_
musth105314783musth
musts75527443musts
musty105620953musty
myotic133112303myotic
mysid11610683mysid
mystics14279103mystics
mystify1843563mystify
myth126715433my_th
nastic82915973nastic
nasty85717283nasty
nest45548733nest_
nests55728003nests
nisei54214353nisei
nisi45823243nis_i
oast47156323oast_
oasts56529183oasts
ostia52315583_ostia
oust46747443oust_
ousts55225703ousts
oyster94111703oyster
past65959013past_
pasta76624533pasta
paste74932953paste
pastie85525523pastie
pastil85018323pastil
pastis84924323pastis
pasts75936503pasts
pasty105725053pasty
pest65555293pest_
pesto75723723pesto
pests75933273pests
pesty106421713pesty
petti75119453petti
piste75824603piste
pistil83915073pistil
posit75833333posit
post67953363post_
postie84123963postie
postin83521033postin
posts75228783posts
psi56621623_ps_i
psst66118403psst_
pst57932513_pst_
putti76018743putti
recti73619623recti
resit54241043resit
rest46459843rest_
rests54935873rests
rishi8311253rishi
roshi8310753roshi
roti46332923_roti
rust45544913rust_
rustic8712673rustic
rusts55026993rusts
rusty85221053rusty
ryot75528563ryot_
ryots85313783ryots
sati45539323_sati
sayst85322003sayst_
sei36048933__sei
senti56226693senti
si29149573__s_i
sit35877753__sit
ski74925683__ski
sri35634003__sri
stir45723243__stir
sty66227313__sty
sushi8310493sushi
syli74318983sy_li
synth113711823synth
sysop1037193sysop
system1135733system
taste55127233taste
tasty84820313tasty
test48651623test_
testa54822043testa
testis64916713testis
tests56530193tests
testy85419063testy
ti28448293___ti
titi47130613_titi
tost48351923tost_
tryst84716223tryst_
tryste9399583tryste
trysts9448793trysts
tutti54614673tutti
upstir835383upstir
vast75045123vast_
vasts86423773vasts
vasty116215923vasty
vest75743603vest_
vesta86618303vesta
vests85325983vests
visit8320963visit
vista85416603vista
volti84915963volti
wast75655853wast_
waste86125053waste
wasts87433673wasts
west75748083west_
wests85727003wests
wist78049293wist_
wists86728523wists
wost76544363wost_
wyte106018643wy_te
xi98128163x___i
xis106935333xis__
xylan1537463xylan
xylem1736123xylem
xyloid1738183xyloid
xylol1546133xylol
xylyl1842563xylyl
xysters17307163xysters
yagi86922243_yagi
yet66960693_yet_
yetis85418393_yetis
yett76434493_yett
yogi86120423_yogi
yoni77524393_yoni
yutz167519883_yutz
zest136035703zest_
zests145419743zests
zesty176512163zesty
ziti136022373_ziti

Search took 4 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 Filter178691836670.1101624463.6
2DLD Change Limit836672673.72022491.1
3Display Results2672670.0763513.2
 (SQL Overall)1786912673.90645747.8
 
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.