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

279 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
grees6513247(None) 
agrees74915321agrees
brees75632551brees
drees65628521drees
frees86131391frees
gees55647881g_ees
ghees95215551ghees
glees65027591glees
grebes93813611grebes
gree56641561gree_
greed75125691greed
greeds84314281greeds
greek105915941greek
green65522141green
greens75716871greens
greet65835321greet
greets75117421greets
greys96614851greys
grues65721961grues
prees75937171prees
rees45364191_rees
trees55835761trees
agree65226032agree_
agreed84712502agreed
akees96119242akees
areas55935772areas
arenes64928392arenes
ares45871022ar_es
aretes64425352aretes
arles56735742arles
arses55733872arses
bees65453382_bees
braes75735052braes
bredes94818472bredes
bree67241262bree_
breed85526692breed
breeds94914882breeds
breeks125310792breeks
brens75823362brens
breves115516422breves
brews105617072brews
bries74942152bries
cees65941592_cees
ceres75540012ceres
creds85418772creds
creed85727392creed
creeds94714772creeds
creek114917392creek
creeks124812922creeks
creel75121482creel
creels84416942creels
creep95218102creep
creeps104213622creeps
creese84014332creese
creesh11328332creesh
cremes104517992cremes
crepes105419342crepes
cress75022832cress
crews105917502crews
cries75438402cries
dees56356632_dees
degrees92810722degrees
dree56638322dree_
dreed75222842dreed
dregs76114862dregs
dreks105714752dreks
dress65319832dress
dries64733672dries
egress73310432egress
egrets72712242egrets
epees75219832epees
ernes55224812ernes
erses55826802erses
fees76450602_fees
feres86038182feres
flees85828752flees
free75940182free_
freed95223542freed
freer86021242freer
freers94717302freers
freest95318282freest
freres94716172freres
frets85523402frets
fries85535602fries
froes86126692froes
gaes56348032g_aes
gages74529972gages
gales65442482gales
games86238552games
gapes86030822gapes
gases65633992gases
gates65939512gates
gazes155425912gazes
geds66730812g_eds
gee45359202g_ee_
geed65435502g_eed
geek95327022g_eek
geeks104915842geeks
geese64316002g_eese
geest64829622g_eest
geez146424862g_eez
gelees74116262gelees
gels56836102g_els
gems75329112g_ems
genes65133092genes
gens55740072g_ens
germs85118872germs
gets55442482g_ets
ghee85726112ghee_
gibes84422522gibes
gies55641422g_ies
gites65630182gites
gives95324872gives
glebes95512242glebes
gledes84915132gledes
gleds75417892gleds
glee55239062glee_
gleed75320572gleed
gleeds84711622gleeds
gleek105315102gleek
gleeks11489672gleeks
gleet65532342gleet
gleets75315052gleets
glens66519852glens
gleys96514852gleys
glues65125682glues
goers65520252goers
goes55644092g_oes
gores65740372gores
gorges85321892gorges
gorses74723292gorses
goxes135018262goxes
grabs85719692grabs
graces94523492graces
grades84926312grades
grads75625752grads
grams85327312grams
grans64832542grans
grapes95123122grapes
grass66125202grass
grates75429892grates
graves104624002graves
grays95621332grays
grazes164519642grazes
grease75416232grease
greases84816712greases
greasy10419462greasy
great66034242great
greats76318392greats
greaves113311442greaves
grebe85114942grebe
greedy11518852greedy
greeny104811452greeny
grego7310522grego
gregos847532gregos
greiges937732greiges
grew85620262gr_ew
grey85624042gr_ey
greyed114610602greyed
greyer104510092greyer
greyest11348342greyest
grides84422362grides
grids75321392grids
grief95319782grief
griefs10418722griefs
grieves1137322grieves
grigs75318192grigs
grimes94619032grimes
grins65427222grins
gripes94619872gripes
grips85520132grips
grits65529582grits
grogs76319412grogs
groks105716122groks
gropes95220402gropes
gross65421692gross
grots65025852grots
groves104318102groves
grows95523922grows
grubs86312602grubs
grue55825712grue_
gruel66014742gruel
gruels73910152gruels
grumes94415552grumes
gudes74520812gudes
guess64213362guess
gules64831042gules
gurges84716862gurges
gybes115012722gybes
gyrenes11267522gyrenes
gyres94820322gyres
gyves125711552gyves
heres86245902heres
hirees95117292hirees
ires45639282ir_es
jees115938542_jees
knees95114872knees
kreep114610412kreep
kreeps12427412kreeps
krewes1337922krewes
larees65323112larees
lees45455882_lees
meres75143572meres
ogees65119142ogees
ogres65818632ogr_es
ogress7529502ogress
ores46056682or_es
orles55326212orles
pees65257372_pees
peres76246642peres
pree67044732pree_
preed85128122preed
preen75925052preen
preens85020112preens
preps96220692preps
prese75228382prese
press75425952press
prexes154915952prexes
preys105717782preys
prezes173614692prezes
pries74339532pries
pugrees10218522pugrees
purees84721682purees
rebs65733562_rebs
recs65734182_recs
redes65139132_redes
reds56042862_reds
ree37974072_ree_
reed55549622_reed
reeds65430902_reeds
reef74938212_reef
reefs85121662_reefs
reek85232522_reek
reeks94124032_reeks
reel45240532_reel
reels55333262_reels
reest54938092_reest
refs75732242_refs
reges65628792_reges
regs55436572_regs
reis45343232_reis
rems66237722_rems
reps65937952_reps
res35565042_r_es
rets45352562_rets
revs75027052_revs
rexes124526952_rexes
roes45954142_roes
rues46044482_rues
ryes75529352_ryes
sarees65329942sarees
screes85023972screes
sees45361052_sees
seres55448892seres
sirees64624582sirees
skees95023122skees
sprees85620642sprees
tees45353582_tees
threes97117322threes
tree47745812tree_
treed65626732treed
treen55622752treen
treens65317872treens
treks96016852treks
tres46542902tr_es
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
tries55742812tries
trues54925322trues
tyees86019452tyees
ureas55826012ureas
urges64619912urges
vees75439432_vees
wees76249122_wees
wrens85016242wrens
wries85827742wries
zees136331892_zees

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 Filter178691538000.296603685.8
2DLD Change Limit538002791.37639098.8
3Display Results2792790.0763671.1
 (SQL Overall)1786912791.748102226.0
 
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.