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

221 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
shy9672819(None) 
ashy107717351ashy
say67264761say
sh56828521sh_
sha69837781sha
shay107133341shay
she66837691she
shh97121071shh
sky106420991sky
sly66228561sly
soy67851451soy
spy86023741spy
sty66227311sty
thy97022911thy
why126920011why
aby810238062aby
achy126316092achy
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
any68440482any
ash67944602ash_
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
bushy135416682bushy
buy86436542buy
by77529232_by
cay87155982cay
chay124924872chay
chi86228652chi
coy810557552coy
cry89726242cry
cushy134412322cushy
dashy125612382dashy
day76254112day
dey77243372dey
dishy125712352dishy
dry76526032dry
eh58339962eh_
espy969372espy
fay97454862fay
fey95940882fey
fishy146011662fishy
fly97124952fly
foy96044262foy
fry96226502fry
gay76856492gay
gey75738302gey
ghi77019882ghi
goy77844552goy
gushy125213122gushy
guy75728942guy
ha510259942_ha
hay97358772hay
he58151952_he
hey96741062hey
hi57947582_hi
hm78126732_hm
ho510258272_ho
hoy97447912hoy
hyp117822462_hyp
icy86322122icy
ivy96317442ivy
jay136242672jay
joy137036362joy
kay106745542kay
key105833332key
khi106318302khi
lay68865352lay
ley66246812ley
mashy136016502mashy
may88757622may
meshy135612782meshy
mho86624622mho
mushy135316632mushy
my78125652_my
nay66952772nay
oh57447002oh_
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oxy136320982oxy
oy58950132_oy
pay88461182pay
phi86524202phi
pht86030522pht
ply86323552ply
pry85728052pry
pushy134614352pushy
ray66361992ray
rho65924832rho
rushy115414812rushy
sab56563202sab
sac57452862sac
sad47459202sad
sae38365182sae
sag46163402sag
sagy85327082sagy
sal36462882sal
sap56463232sap
sat36288482sat
sau36356572sau
saw68255352saw
sax107447642sax
says75942102says
scry96017762scry
sea36161292sea
sec55945322sec
see35772262see
seg45544882seg
sei36048932sei
sel38253322sel
sen36058522sen
ser36752402ser
set36681252set
sew66247262sew
sex107043222sex
sexy146418022sexy
shad86230912shad
shady125416512shady
shag86430562shag
shah105627782shah
shaky154616842shaky
shaly114322862shaly
sham96436352sham
shat76456592shat
shaw108132552shaw
shays116021432shays
shea76031572shea
shed86536152shed
shes75734352shes
shew108030762shew
shily115222012shily
shim95827842shim
shin75634302shin
shiny115122142shiny
ship95228232ship
shit76745932shit
shiv105721162shiv
shmo95318092shmo
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
showy145714002showy
shoyu1138902shoyu
shri76021692shri
shul75823152shul
shun75122772shun
shut76137582shut
shwa106014962shwa
shyer114714782shyer
shyly144811572shyly
si29149572s_i
sib56850312sib
sic55847872sic
sim56553132sim
sin36265892sin
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
sizy164816392sizy
ska76925862ska
ski74925682ski
slay76436382slay
snye77115492snye
so28855442s_o
sob57857942sob
sod46053702sod
sol37256622sol
som59153802som
son37761952son
sop57557862sop
sophy136611762sophy
sos37761602sos
sot310384292sot
sou37853692sou
sow66554762sow
sox106444192sox
soya75724432soya
soys75233932soys
spa55730812spa
spay96631662spay
spry96819122spry
sri35634002sri
stay78333722stay
stey76224412stey
stye76218972stye
sub55445552sub
sue35651462sue
suk75632972suk
sum56346012sum
sun37149032sun
sup57041942sup
suq126228992suq
sway107128232sway
syn67024122syn
the67436052the
they107223752they
tho67433962tho
toy69655192toy
try66529672try
tushy114212992tushy
uh57429852uh_
washy145911842washy
way96757662way
wha96422072wha
whey135018712whey
who95526772who
whys137011662whys
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.0632836365.1
2DLD Change Limit140842210.35639561.8
3Display Results2212210.0464804.3
 (SQL Overall)1786912210.465384281.7
 
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.