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

205 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
chay12492487(None) 
cay87155981c_ay
chad105525501chad
chai95929901chai
cham115532311cham
chao95727311chao
chap114928491chap
char95132151char
chary135023131chary
chat95546131chat
chaw126224631chaw
chays135319741chays
clay95927411clay
hay97358771_hay
shay107133341shay
achy126316092ach_y
aha611246642aha_
ahoy101919182ahoy
away108024222away
ay511773892__ay
bay89661642_bay
bray95232902bray
cab78355402c_ab
cad67456362c_ad
cagy106321992cagy
caky136222442caky
cam78058982c_am
can57760142c_an
cap76758982c_ap
car59165562c_ar
cat58282342c_at
cavy125920002cavy
caw86647932c_aw
cays95437672c_ays
chads116122232chads
chafe135117352chafe
chaff165016282chaff
chaffy20456472chaffy
chain105723672chain
chair105519632chair
chais107530312chais
chalk144814602chalk
chalky18468772chalky
chally144314292chally
chammy18488952chammy
champ145017962champ
champy18509612champy
chams126028502chams
chancy164010862chancy
chang115418562chang
chant105932692chant
chanty145215822chanty
chaos105622862chaos
chape125221142chape
chaps125326062chaps
chapt125827642chapt
chard116124742chard
chare105231982chare
chark144222712chark
charm126124662charm
charr104821782charr
charry145012112charry
chars105936642chars
chart105038282chart
chase105127122chase
chasm125518792chasm
chasmy16468542chasmy
chats105730092chats
chatty14419362chatty
chaws135022462chaws
cheap126915942cheap
cheat105732452cheat
chef125125622chef
chevy16479992chevy
chew126622132chew
chewy165011902chewy
chez184519022chez
chi86228652ch_i
chia96026622chia
chiao105618362chiao
chias104625522chias
chic115925202chic
chid106626402chid
chin96934742chin
chip116726422chip
chis95933312chis
chit96937462chit
chivy164810362chivy
choky175711222choky
chon96627792chon
chop116024922chop
chow125820992chow
chub115516412chub
chug105914112chug
chum116318002chum
ciao64924182ciao
city95122622city
clad76225822clad
clag75924572clag
clam86332292clam
clan65633922clan
clap86429042clap
clary105719612clary
claw95624342claw
clays105521332clays
cloy96623832cloy
coal66939252coal
coaly105521592coaly
coat67558352coat
coax136922982coax
coky137526822coky
coly96940532coly
cony96537832cony
copay126516312copay
copy116229802copy
cory96941512cory
cosy97232702cosy
cowy126427362cowy
coy810557552c_oy
cozy185823802cozy
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
crazy195511222crazy
cry89726242c_ry
cyan96419622cyan
czar156013132czar
day76254112_day
dhak125512032dhak
dhal86719282dhal
dray85428092dray
fay97454862_fay
flay106332802flay
fray105428902fray
gay76856492_gay
ghat86435282ghat
gray85329892gray
ha510259942_ha_
had77658762_had
hae67364002_hae
hag77255742_hag
hah910655222_hah
haj138140602_haj
ham86363282_ham
hao67251122_hao
hap87360052_hap
has67372652_has
hat67289962_hat
haw97153272_haw
hays106138072_hays
hazy1918119192_hazy
hey96741062_hey
hoy97447912_hoy
jay136242672_jay
kay106745542_kay
khaf145319602khaf
khan115819142khan
khat116730722khat
lay68865352_lay
may88757632_may
nay66952772_nay
ochry13346932ochry
ofay106416102ofay
okay115917662okay
pay88461182_pay
phat95837862phat
play95928982play
pray96331532pray
quay164618352quay
ray66361992_ray
say67264762_say
schav1338312schav
sha69837782sha_
shad86230912shad
shady125416512shady
shag86430562shag
shah105627782shah
shaky154616842shaky
shaly114322862shaly
sham96436362sham
shat76456602shat
shaw108132552shaw
shays116021432shays
shy96728192sh_y
slay76436382slay
spay96631662spay
stay78333722stay
sway107128232sway
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
they107223752they
thy97022912th_y
tray77632592tray
way96757662_way
wha96422072wha_
wham125321692wham
whap125119642whap
what105434072what
whey135018712whey
why126920012wh_y
yay96948712_yay

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.263679433.5
2DLD Change Limit298722050.78338150.7
3Display Results2052050.0464456.5
 (SQL Overall)1786912051.092163636.4
 
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.