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

261 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
sagy8532708(None) 
cagy106321991cagy
sag46163401sag_
saga55331171saga
sage55044591sage
saggy105917461saggy
sago56332671sago
sags55948401sags
say67264761sa_y
stagy96618891stagy
aby810238062_aby
ag311067462_ag_
aga410447232_aga
age47154332_age
agly86821802_agly
ago48845522_ago
ags47551662_ags
any68440492_any
ashy107717352ashy
ay511773892_a_y
baby116723682baby
bag67059222bag_
baggy125615682baggy
bags76645502bags
bay89661642ba_y
bogy106426192bogy
cadgy125210782cadgy
cage75339062cage
cagey115917822cagey
caky136222442caky
cavy125920002cavy
cay87155982ca_y
dag57753012dag_
dago65725092dago
dags66642602dags
davy116015522davy
day76254112da_y
dogy96126492dogy
easy76224492easy
edgy94713532edgy
eggy96611852eggy
fag76852362fag_
faggy136514372faggy
fags86939122fags
fay97454862fa_y
fogy115923182fogy
gaby107123192gaby
gag57753632gag_
gaga66625552gaga
gage65936102gage
gags66441062gags
gamy105427532gamy
gapy106320912gapy
gay76856492ga_y
hag77255742hag_
hags86740842hags
hay97358772ha_y
hazy1918119192hazy
hoagy124710472hoagy
jag116542712jag_
jagg136115312jagg
jaggy175913142jaggy
jags126132792jags
jay136242672ja_y
kagu95418122kagu
kay106745552ka_y
lacy95829632lacy
lady86527162lady
lag47862122lag_
lags56546222lags
laky116725822laky
lay68865352la_y
lazy166423072lazy
logy87025782logy
mag67956482mag_
mage75739132mage
magi76329532magi
mags75444532mags
mangy115021252mangy
many95731862many
may88757632ma_y
mazy186419702mazy
nag46450812nag_
naggy106612822naggy
nags55436022nags
nary76931222nary
navy107518632navy
nay66952772na_y
oaky116419952oaky
orgy85218002orgy
pacy115328682pacy
page76036102page
paly95835532paly
paty95234562paty
pay88461182pa_y
pogy105623552pogy
racy95825682racy
rag45761322rag_
raga55930812raga
rage55742352rage
ragg65622692ragg
raggy106116572raggy
ragi56032282ragi
rags55448372rags
rangy95320392rangy
ray66361992ra_y
sab56563202sa_b
sabe66140572sabe
sabs66643742sabs
sac57452862sa_c
sack105337312sack
sacs65739072sacs
sad47459212sa_d
sade55544482sade
sadi55834652sadi
sadly94519122sadly
sae38365182sa_e
safe75930952safe
sagas66025882sagas
sagely102811382sagely
sager65432052sager
sages65339062sages
sagos66123872sagos
sagum8512872sagum
said55742122said
saiga64717932saiga
sail45447162sail
sain45551292sain
sake85244962sake
saki85628482saki
sal36462882sa_l
sale44959702sale
sall44544682sall
sally85129712sally
salp64534092salp
sals46851672sals
salt45758522salt
salty85524382salty
same65245642same
samp85733592samp
sand55338472sand
sandy94221132sandy
sane45954342sane
sang55441242sang
sanga66023802sanga
sangh95517462sangh
sank85236832sank
sans45153362sans
sap56463232sa_p
sappy125413472sappy
saps65346372saps
sard55344242sard
sarge65531132sarge
sargo65424412sargo
sari45444042sari
sark84938972sark
sarky125521782sarky
sash77235302sash
sass45035622sass
sassy85813812sassy
sat36288482sa_t
satay84718462satay
sate45556102sate
sati45539332sati
satyr848482satyr
sau36356572sa_u
saucy104615162saucy
saugh95318402saugh
saughy13507462saughy
saul45836522saul
saury84317222saury
save75741362save
savoy114713882savoy
savvy14497502savvy
saw68255352sa_w
sawn75428162sawn
saws75839482saws
sax107447642sa_x
says75942102says
scag76626892scag_
scags85520972scags
scaly104718722scaly
scary105222592scary
scry96017762scry
seamy105921272seamy
sedgy104512792sedgy
seg45544882seg_
sego56525182sego
segs54933882segs
sexy146418022sexy
shady125416512shady
shag86430562shag_
shaggy14478042shaggy
shags95123862shags
shaky154616842shaky
shaly114322862shaly
shay107133342shay
shy96728192s_hy
sigh85625902sigh
sign55523062sign
sizy164816402sizy
skag96321512skag_
skags104316072skags
sky106420992s_ky
slag55934352slag_
slaggy11438792slaggy
slags66525902slags
slangy105411392slangy
slaty86523152slaty
slay76436382slay
sly66228562s_ly
snag55827872snag_
snaggy11488052snaggy
snags64421312snags
snaky125113912snaky
soapy106114782soapy
soggy105413902soggy
soy67851452s_oy
spacy125415622spacy
spay96631662spay
spry96819122spry
spy86023742s_py
stag57332002stag_
stage65330192stage
stagey105915582stagey
staggy115510392staggy
stags66226742stags
stay78333722stay
stey76224412stey
stogy95414082stogy
sty66227312s_ty
sugh86423442sugh
surgy95118522surgy
swag87526732swag_
swage94919562swage
swags94921252swags
swamy136714402swamy
sway107128232sway
tag47259502tag_
tags55545242tags
tangy94519952tangy
usage6410212usage
vagi86719362vagi
vary105226062vary
wady115325002wady
wag76451752wag_
wage84834082wage
wags86140552wags
waly105830902waly
wany106432362wany
wary106740012wary
wavy136620472wavy
waxy175918202waxy
way96757662wa_y
yag76947732yag_
yagi86922242yagi
yags86632292yags
yay96948712ya_y
zag137539472zag_
zags146826682zags
zany167316992zany

Search took 2 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 Filter178691298720.283631417.0
2DLD Change Limit298722610.98330388.6
3Display Results2612610.0634142.9
 (SQL Overall)1786912611.329134455.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.