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

228 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
gray8532989(None) 
bray95232901bray
dray85428091dray
fray105428901fray
gay76856491g_ay
grab75427611grab
grad66829861grad
gram77034581gram
gran56335011gran
grapy115416431grapy
grat55651281grat
gravy125512111gravy
grays95621331grays
grey85624041grey
pray96331531pray
ray66361991_ray
tray77632591tray
arak86929572arak
army96624182army
array86317142array
arty77531312arty
away108024222away
ay511773892__ay
bay89661642_bay
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
braky145015812braky
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
braxy175410892braxy
brays106723112brays
cay87155982_cay
chay124924872chay
clay95927412clay
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
crazy195511222crazy
cry89726242cr_y
day76254112_day
deray95024182deray
drab76226452drab
drag64825052drag
dram75832002dram
drat56247832drat
draw85623012draw
drays95819772drays
dry76526032dr_y
era35741502era_
eras45441502eras
fay97454862_fay
flay106332802flay
foray115023972foray
frae75330472frae
frag85126272frag
frap95925812frap
frat75648542frat
frays116920102frays
fry96226502fr_y
gab67155992g_ab
gaby107123192gaby
gad57556652g_ad
gae46457702g_ae
gag57753632g_ag
gal46055512g_al
gam67060062g_am
gamay116419102gamay
gamy105427532gamy
gan48060122g_an
gap67055612g_ap
gapy106320912gapy
gar47259902g_ar
garb75332672garb
gars55750742gars
gas48870252g_as
gat46880512g_at
gays87338022g_ays
gear55934972gear
gerah9315302gerah
germy115113662germy
gey75738302g_ey
ghat86435282ghat
girly94415292girly
glad65624012glad
glady105413942glady
glam76529342glam
glary96018542glary
glazy187410982glazy
gley85724652gley
gnar56021382gnar
gnat56034432gnat
gnaw86515742gnaw
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goat56250832goat
goby106021082goby
goral65125752goral
gorsy95915782gorsy
gory86129662gory
goy77844552g_oy
graal64316502graal
grabby14336182grabby
grabs85719692grabs
grace85124542grace
grade75126092grade
grads75625752grads
graft95327202graft
grail64622872grail
grain65126252grain
grainy103914212grainy
grama85620272grama
gramp106218322gramp
grams85327312grams
grana65722082grana
grand75122692grand
granny104311162granny
grans64832542grans
grant64840012grant
grape84824662grape
grapey126012302grapey
graph115315612graph
grasp84814482grasp
grass66125202grass
grassy10619092grassy
grate64932882grate
grave94624872grave
grayed115415642grayed
grayer106014542grayer
grayly13287962grayly
graze155820052graze
greasy10419462greasy
great66034242great
gree56641562gree
grew85620262grew
greys96614852greys
grid65829612grid
grig65424772grig
grim76929422grim
grimy114312602grimy
grin55733722grin
grip76127022grip
gripy115115252gripy
grit55247242grit
groan65618422groan
groat65531962groat
grody103412062grody
grog65923342grog
grok95819682grok
grot55942052grot
grow86127302grow
grub77220082grub
grue55825712grue
grum75625082grum
guan55325582guan
guar56923292guar
gurry94515412gurry
guy75728942g_uy
gyral94412782gyral
hay97358772_hay
jay136242672_jay
kay106745542_kay
lay68865352_lay
may88757622_may
moray105423792moray
nary76931222nary
nay66952772_nay
ofay106416102ofay
okay115917662okay
ora37250832ora_
orad56031692orad
oral47638122oral
orby97519602orby
orgy85218002orgy
pay88461182_pay
play95928982play
pram85733492pram
prao66229022prao
prat65952042prat
prau66529472prau
prays105022432prays
prey96228482prey
pry85728052pr_y
quay164618352quay
racy95825682_racy
rad47662002_rad
rag45761322_rag
rah68052402_rah
rai37658222_rai
raj105740222_raj
ram56867272_ram
ran38266612_ran
rap56261962_rap
ras37575392_ras
rat37892742_rat
raw67252252_raw
rax108445722_rax
raya75224822_raya
rays77642352_rays
rya67622012_rya
say67264762_say
shay107133342shay
slay76436382slay
spay96631662spay
spray106720062spray
stay78333722stay
stray88525572stray
sway107128232sway
trad55630912trad
tram67034552tram
trap67532802trap
trays85623432trays
trey77228792trey
troy77429682troy
try66529672tr_y
vary105226062vary
wary106740012wary
way96757662_way
wrap96821972wrap
wry96524702wr_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.0931921408.6
2DLD Change Limit298722280.87634100.5
3Display Results2282280.0633619.0
 (SQL Overall)1786912281.032173150.2
 
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.