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

273 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
lyttas98507(None) 
lytta888061lytta_
lyttae994711lyttae
bettas84913922bettas
cottas84615572cottas
fyttes1236932fyttes
gyttjas1841002gyttjas
lattes65324202lattes
litas54923772l_itas
lotas55926302l_otas
lottes65322752lottes
lottos64613102lottos
lycras11287242lycras
lyssas935442lyssas
pittas86014522pittas
suttas63813792suttas
agitas7310593agitas
albatas938373albatas
antas55432033_antas
aortas65417783aortas
atlas55821583_atlas
atmas75721013_atmas
attar56516693_attar
attars64515313_attars
batts76727563batt_s
betas75528763_betas
betta74916843betta_
biotas84313923biotas
bitts75022593bitt_s
botas75328783_botas
botts75224863bott_s
buttals938503buttals
buttes84822563buttes
butts75824253butt_s
bytes105217493by_tes
centas85020703centas
cestas85018543cestas
cotta75818573cotta_
cottae84615703cottae
cottar84613813cottar
cottars94412233cottars
cutlas8313093cutlas
cycas126513823cy_cas
cymas126417883cy_mas
cysts105912773cyst_s
cytons111710183cytons
dattos74311903dattos
deltas74414823deltas
ditas65923673_ditas
dittos74111973dittos
elytra934893elytra_
etas46432273__etas
etnas54713933_etnas
extras13310223extras
eyas76427433ey__as
eyras84715923ey_ras
fatwas1249053fatwas
fetas85624403_fetas
flautas1036153flautas
flotas94013003flotas
flytes123911563fly_tes
flytrap1543253flytrap
flytraps1642963flytraps
fytte1138583fytt_e
getas65421483_getas
glottal835103glottal
glottis837163glottis
gutta64613383gutta_
guttae73210583guttae
gyozas1933603gyozas
gyttja1741573gyttja
hostas94515823hostas
hydras13239313hydras
hyenas1288953hyenas
hyetal1236543hyetal
hylas114815903hy_las
iotas54821113_iotas
jotas125717443_jotas
juntas134210503juntas
katas95922093_katas
kurtas10349883kurtas
kyats125012443kyat_s
kytes125012913ky_tes
kythes16499133kythes
lactam10310943lactam
lactams1136953lactams
lactase937953lactase
lamas75532793l_amas
lamias85020613lamias
lampas106615953lampas
larvas9310233larvas
las37281473l___as
lasts57731263last_s
latens64620213latens
lathes95127493lathes
lathis95516173lathis
laths86022403l_aths
latinas74416463latinas
latkes104715873latkes
latrias71913213latrias
lats45962703l_at_s
latte55426303latt_e
latten65018203latten
lattens75014673lattens
latter65027893latter
lattin64316223lattin
lattins74115483lattins
lauras63414333lauras
lavas85422223l_avas
layettes1136263layettes
leas45954183l__eas
leets54927123leet_s
lefts86517813left_s
lehuas935943lehuas
lemmas10349163lemmas
lentos65317403lentos
lepta75714393lepta_
lethal939803lethal
lethals1038113lethals
lethes94818083lethes
lets47147943l_et_s
letted74118543letted
letter63722583letter
letters73819853letters
letups8317683letups
lianas63713383lianas
libras83711703libras
lifts85719063lift_s
lilts55822803lilt_s
limas75627633l_imas
limbas105313193limbas
limpas105513083limpas
lingas75116563lingas
lints57137193lint_s
liras56021983l_iras
lists56628693list_s
litai55216363l_itai
liters65429873liters
lithias1038823lithias
lithos94212553lithos
litmus836323litmus
litotes7311183litotes
litres65220393litres
lits46252493l_it_s
litten64014873litten
litter64324853litter
litters73422563litters
little63312163little
littles73212783littles
llamas888973llamas
lofts85518363loft_s
loofas9429833loofas
loots55431423loot_s
lota47233503l_ota_
lotah85315853l_otah
lotahs9479873lotahs
lotos54724633l_otos
lots47652093l_ot_s
lotte54923853lott_e
lotted74222403lotted
lotter64025603lotter
lotters73921063lotters
lotto55217573lott_o
lotus55718063l_otus
loumas84812333loumas
louts56330273lout_s
lovats939073lovats
luffas12337483luffas
lumas75622913l_umas
lunas55025013l_unas
lunts55826903lunt_s
lusts55022803lust_s
lutea54819073lutea_
luteal64411483luteal
lutes55836663l_utes
lutzes153711923lutzes
lyase85512413ly__ase
lyases95211873lyases
lycea10418943lycea_
lycees11428863lycees
lyches144213613lyches
lycra10317973lycra_
lyes75530833ly__es
lyings10488503lyings
lymphs1635053lymphs
lynxes1634323lynxes
lyrate94112103lyrate
lyres85019963ly_res
lyrics11357943lyrics
lysate9388103lysate
lysates10317473lysates
lyses84518253ly_ses
lysins94610953lysins
lysis84511463ly_sis
lyssa835713lyssa_
lytic104513033ly_tic
mantas85725363mantas
mattes85624533mattes
matts76829183matt_s
matzas1749703matzas
mitts75523753mitt_s
mottes85523693mottes
mottos84615243mottos
motts76527003mott_s
mutts75120253mutt_s
mynas105815233my_nas
myomas1338293myomas
mythos14398463mythos
myths135911603my_ths
netts55320723nett_s
nyalas936903nyalas
ottar54313993_ottar
ottars64112223_ottars
ottos54714323_ottos
outgas7313203outgas
outtask1137053outtask
pastas85422873pastas
pietas84516503pietas
pintas85021393pintas
pitas77427673_pitas
pitta75018693pitta_
pottos84615873pottos
putts75719273putt_s
pyas96225703py__as
quotas15339433quotas
raitas64417673raitas
rattan63613603rattan
rattans73411953rattans
reatas64021013reatas
riatas63915083riatas
rotas54827723_rotas
rottes64524833rottes
ryas77224613ry__as
ryots85313783ryot_s
setts55124323sett_s
softas94410403softas
stats55933363_stats
stoas55126023_stoas
sutras64818583sutras
sutta54015333sutta_
sylvas12288173sylvas
syngas10368913syngas
syntax1634303syntax
synths12377883synths
tas38477103___tas
tats46858133__tats
teas45851493__teas
tetras63017613tetras
thetas93011573thetas
tortas64918253tortas
tuttis63611373tuttis
twas76824083__twas
tythes12419703tythes
ultras6310183ultras
utas45924953__utas
vestas95916683vestas
vistas94513273vistas
vitta85015173vitta_
vittae93910993vittae
watts86923093watt_s
wytes114113433wy_tes
xystos16356913xystos
xysts15558123xyst_s
xystus16354423xystus
yeas78638423_y_eas
yentas94614213yentas
yetis85418393_yetis
yetts86715133_yetts
yogas96615603_yogas
yttrias1044513_yttrias
yucas106013913_yucas
yugas95012063_yugas
zetas145018163_zetas

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.1561145455.1
2DLD Change Limit1127162735.50020493.8
3Display Results2732730.0932935.5
 (SQL Overall)1786912735.74931082.1
 
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.