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

230 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
sty6622731(None) 
say67264761say
shy96728191shy
sky106420991sky
sly66228561sly
soy67851451soy
spy86023741spy
stay78333721stay
stey76224411stey
stye76218971stye
aby810238062aby
any68440492any
arty77531312arty
ashy107717352ashy
at212393402at_
ate37059242ate
att35454652att
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
busty105621012busty
buy86436542buy
by77529232_by
cay87155982cay
city95122622city
coy810557552coy
cry89726242cry
day76254112day
dey77243372dey
doty86128222doty
dry76526032dry
dusty96018322dusty
duty85321452duty
espy969372espy
et26964192et_
eta35834192eta
eth66630982eth
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fry96226502fry
fusty115016512fusty
gay76856492gay
gey75738302gey
goy77844552goy
gusty95119572gusty
guy75728942guy
hasty115718762hasty
hay97358772hay
hey96741062hey
hoy97447912hoy
icy86322122icy
it28455682it_
its35538832its
ivy96317442ivy
jay136242672jay
joy137036362joy
kay106745542kay
key105833332key
lay68865352lay
ley66246812ley
lusty85417572lusty
may88757632may
misty106120452misty
mity95528212mity
musty105620952musty
my78125652_my
nasty85717282nasty
nay66952772nay
nth66320592nth
oxy136320982oxy
oy58950132_oy
pasty105725052pasty
paty95234562paty
pay88461182pay
pesty106421712pesty
pity96031932pity
ply86323552ply
pry85728052pry
pst57932512pst_
ray66361992ray
rusty85221052rusty
sab56563202sab
sac57452862sac
sad47459202sad
sae38365182sae
sag46163402sag
sagy85327082sagy
sal36462882sal
salty85524382salty
sap56463232sap
sat36288482sat
satay84718462satay
sate45556102sate
sati45539332sati
satyr848482satyr
sau36356572sau
saw68255352saw
sax107447642sax
says75942102says
scry96017762scry
sea36161292sea
sec55945322sec
see35772262see
seg45544882seg
sei36048932sei
sel38253322sel
sen36058522sen
ser36752402ser
set36681252set
seta45637312seta
sets45549502sets
sett45949052sett
sew66247262sew
sex107043222sex
sexy146418022sexy
sh56828522s_h
sha69837782sha
shay107133342shay
she66837692she
shh97121072shh
si29149572s_i
sib56850312sib
sic55847872sic
silty84721632silty
sim56553142sim
sin36265892sin
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
site47052412site
sith75435152sith
sits45050202sits
six105339742six
sixty154912732sixty
sizy164816392sizy
ska76925862ska
ski74925692ski
slaty86523152slaty
slay76436382slay
snye77115492snye
so28855442s_o
sob57857942sob
sod46053702sod
softy115414482softy
sol37256622sol
som59153812som
son37761952son
sooty84924842sooty
sop57557862sop
sos37761602sos
sot310384302sot
soth75932522soth
sots45552452sots
sou37853692sou
sow66554762sow
sox106444192sox
soya75724432soya
soys75233932soys
spa55730812spa
spay96631662spay
spry96819122spry
sri35634002sri
stab67329932stab
stag57332002stag
stagy96618892stagy
star48037762star
stat47352692stat
staw78627692staw
stays86022022stays
stem610628252stem
step67126292step
stet45947322stet
stew77525462stew
stewy116112062stewy
stimy105114742stimy
stir45723252stir
stoa45425912stoa
stob66724612stob
stogy95414082stogy
stony85818642stony
stop66532032stop
story86723032story
stot46347332stot
stow77325742stow
stray88525572stray
stroy87720392stroy
stub66221842stub
stud56220092stud
study94411792study
stum65526022stum
stun45623452stun
styed95815482styed
styes86316522styes
style85519362style
styli83911172styli
stymy13358292stymy
sub55445552sub
sue35651462sue
suety85318492suety
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
sway107128232sway
syn67024122syn
ta211662452_ta
tasty84820312tasty
testy85419062testy
thy97022912thy
ti28448292_ti
to218858982_to
toy69655192toy
try66529672try
tsk75814732tsk
tye65837442_tye
ut28647032ut_
uta37425582uta
ute35335882ute
uts35534372uts
vasty116215922vasty
way96757662way
why126920012why
wry96524702wry
yay96948712yay
zesty176512162zesty

Search took 1 second 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 Filter178691140840.266671770.7
2DLD Change Limit140842300.43632302.8
3Display Results2302300.0465000.0
 (SQL Overall)1786912300.748238891.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.