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 “greenest” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

155 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
greenest931262(None) 
greeniest1039031greeniest
freeness11710442freeness
greatest939862greatest
greediest1147552greediest
greenbelt1243972greenbelt
greened93111262greene_d
greener83111712greene_r
greenery12265922greenery
greenies9312672greenies_
greenish1247082greenish
greenlet948512greenlet
greenlets1044702greenlets
greenlit945802greenlit
greenness1046792greenness
greens75716872green_s_
greyest11348342gr_eyest
greyness1235242greyness
keenest11410962_keenest
renest64529712_r_enest
serenest82717622serenest
agreement1256453agreement
arbelest1049503arbelest
arenes64928393ar_enes_
barrenest1149563barrenest
breezes18318693breezes_
breeziest2035063breeziest
briefest1335893briefest
brownest1398893brownest
cleanest10310293cleanest
creepiest1337063creepiest
creeses93914623creeses_
crepiest12310383crepiest
cruelest1059183cruelest
deepest10310443_deepest
evenest10312103_evenest
fleetest1136723fleetest
freest95318283fr_e_est
freezes193310353freezes_
freshest143010583freshest
gameness112810693gameness
geekiest13257873geekiest
geest64829623g__e_est
genes65133093g__enes_
genet66038683g__ene_t
genets75716663g__enets
gerent73223103geren__t
gerents82612923gerents_
germiest11249923germiest
gleetiest1035913gleetiest
glegness1034613glegness
goldenest1147873goldenest
goneness9310763goneness
grainiest10188993grainiest
grandest10311573grandest
grapiest112211933grapiest
graveness13288383graveness
gravest114011633gr_avest
grayest11489363gr_ayest
grayness1235933grayness
greases84816713greases_
greasiest10208563greasiest
greatness1036903greatness
greaves113311443greaves_
grebes93813613gr_ebes_
greediness1245833greediness
greedless1144893greedless
greeds84314283gree_ds_
green65522143green___
greenbelts1352453greenbelts
greenbug1242633greenbug
greenfly1554083greenfly
greenhead1443163greenhead
greenheart1453183greenheart
greenie8310123green_ie
greenier938713greenier
greening103112533greening
greenly11408193green_ly
greenth11116723green_th
greenths1295213greenths
greenwash1642403greenwash
greenway1543853greenway
greeny104811453green__y
grees65132473gr_e_es_
greet65835323gr_e_e_t
greeted93111383greete_d
greeter82812673greete_r
greeters92610113greeters
greets75117423gree_ts_
greiges937733greiges_
grieves1137323grieves_
grimiest11299823grimiest
grimmest13286293grimmest
grimness1175993grimness
gripiest11289633gripiest
grodiest10310553grodiest
grossest93810093grossest
groynes1137823groynes_
gruffest1544593gruffest
grummest13286363grummest
gyrenes11267523gyrenes_
leanest7415863_leanest
meanest9315703_meanest
meekest1336893_meekest
oftenest1148863oftenest
openest9312913_openest
preelect1249643preelect
preenact12410183preenact
preened103214993preene_d
preener93114833preene_r
preeners102712813preeners
preens85020113preen_s_
preerect1259273preerect
preexist1747963preexist
pretest9517633pr_etest
queerest1746273queerest
realest73322433_realest
recentest11410283_recentest
reddest9311953_reddest
redness82012443_redness
reediest92815423_reediest
reefiest112811483_reefiest
reeject16349623_reeject
reekiest122711313_reekiest
reelect911515633_reelect
reenact9413013_reenact
reenlist8410363_reenlist
reerect92915883_reerect
reest54938093_r_e_est
reeves94721493_reeves_
reinvest1138203_reinvest
renests74014213_r_enests
rennet64624853_renne_t
rennets75212633_rennets
request16311023_request
retenes76324623_retenes_
retest64028453_r_etest
revest94623603_r_evest
serenes73222903serenes_
sheeniest12158363sheeniest
sheerest11310083sheerest
sleekest1236153sleekest
steepest1038123steepest
sternest8314433sternest
sweetest1137173sweetest
teeniest82112413_teeniest
trapnest10310923trapnest
treeless839283treeless
treens65317873treen_s_
trienes74118413trienes_
trueness838693trueness
tweeness11246403tweeness
unevenest1247473unevenest
urbanest10117533urbanest
weeniest112411213_weeniest

Search took 8 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 Filter1786911461620.453394461.4
2DLD Change Limit1461621557.14020470.9
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.65623340.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.