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

263 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
sly6622856(None) 
fly97124951fly
ply86323551ply
say67264761say
shy96728191shy
sky106420991sky
slay76436381slay
soy67851451soy
spy86023741spy
sty66227311sty
ably99725132ably
aby810238062aby
agly86821802agly
al210674042al_
ala312463602ala
alb57342652alb
ale36572342ale
alky115920342alky
all36148232all
ally76935642ally
alp56641132alp
als36663022als
alt36467962alt
any68440482any
ashy107717352ashy
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
buy86436542buy
by77529232_by
cay87155982cay
clay95927412clay
cloy96623832cloy
coly96940532coly
coy810557552coy
cry89726242cry
day76254112day
dey77243372dey
dry76526032dry
duly85323032duly
eely77725212eely
el26745292el_
eld46733792eld
elf66138522elf
elk76726122elk
ell36735682ell
elm57531742elm
elmy95616792elmy
els37645722els
espy969372espy
fay97454862fay
fey95940882fey
flay106332802flay
fley106626852fley
flu66530212flu
foy96044262foy
fry96226502fry
gay76856492gay
gey75738302gey
gley85724652gley
goy77844552goy
guy75728942guy
hay97358772hay
hey96741062hey
holy106333432holy
hoy97447912hoy
icy86322122icy
idly85617322idly
ilk78325302ilk
ill37437092ill
illy76925332illy
inly75622212inly
isle45121702isle
ivy96317442ivy
jay136242672jay
joy137036362joy
kay106745542kay
key105833332key
la219261632_la
lay68865352lay
ley66246812ley
li29948752_li
lily76730182lily
lo28053442_lo
lye66533412_lye
may88757622may
moly96031912moly
my78125652_my
nay66952772nay
oily77932252oily
old47033462old
oldy85316842oldy
ole37155212ole
only75319722only
oxy136320982oxy
oy58950132_oy
paly95835532paly
pay88461182pay
pily96132732pily
play95928982play
ploy96123602ploy
poly96235152poly
pry85728052pry
ray66361992ray
rely75428952rely
ruly76323142ruly
sab56563202sab
sac57452862sac
sad47459202sad
sadly94519122sadly
sae38365182sae
sag46163402sag
sagy85327082sagy
sal36462882sal
sale44959702sale
sall44544682sall
sally85129712sally
salp64534092salp
sals46851672sals
salt45758522salt
salty85524382salty
sap56463232sap
sat36288482sat
sau36356572sau
saw68255352saw
sax107447642sax
says75942102says
scaly104718722scaly
scry96017762scry
sea36161292sea
sec55945322sec
see35772262see
seely84522632seely
seg45544882seg
sei36048932sei
sel38253322sel
self75138292self
sell45840612sell
sels46345982sels
sen36058522sen
ser36752402ser
set36681252set
sew66247262sew
sex107043222sex
sexy146418022sexy
sh56828522s_h
sha69837782sha
shaly114322862shaly
shay107133342shay
she66837692she
shh97121072shh
shily115222012shily
shyly144811572shyly
si29149572s_i
sib56850302sib
sic55847872sic
sild55030582sild
silk85529322silk
silky125315822silky
sill45545152sill
silly84527612silly
silo46037912silo
silt46558192silt
silty84721632silty
sim56553132sim
sin36265892sin
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
sizy164816392sizy
ska76925862ska
ski74925682ski
slab67133762slab
slag55934352slag
slam67737972slam
slap66434042slap
slat46959022slat
slaty86523152slaty
slaw77930712slaw
slays85723682slays
sled55334372sled
slew76228232slew
slid55828982slid
slily85820032slily
slim66631952slim
slimy105417422slimy
slip67031732slip
slit46250102slit
slob66029422slob
sloe45534952sloe
slog56728272slog
slop66533872slop
slot46049822slot
slow77729492slow
sloyd9409682sloyd
slub65428032slub
slue45332192slue
slug55124642slug
slum65430512slum
slur45525152slur
slut45040592slut
slyer85515122slyer
slyly11489532slyly
slype105112362slype
snye77115492snye
so28855442s_o
sob57857942sob
sod46053702sod
sol37256622sol
sola45541862sola
sold54837412sold
sole46053672sole
soli46637002soli
solo45538942solo
sols45448162sols
som59153802som
son37761952son
sonly85718052sonly
sop57557862sop
sos37761602sos
sot310384292sot
sou37853692sou
sow66554762sow
sox106444192sox
soya75724432soya
soys75233932soys
spa55730812spa
spay96631662spay
splay105816042splay
spry96819122spry
sri35634002sri
stay78333722stay
stey76224412stey
stye76218972stye
sub55445552sub
sue35651462sue
suk75632972suk
sulk85326652sulk
sulky124715362sulky
sully84622892sully
sulu45128422sulu
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
surly85124422surly
sway107128232sway
syli74318982syli
syn67024122syn
thy97022912thy
toy69655192toy
try66529672try
ugly86012382ugly
ulu36028702ulu
waly105830902waly
way96757662way
why126920012why
wily106428812wily
wry96524702wry
yay96948712yay

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.0802233637.5
2DLD Change Limit140842630.42033533.3
3Display Results2632630.0634174.6
 (SQL Overall)1786912630.563317390.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.