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

187 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
greatest93986(None) 
creates95225202creates_
featest102715112_featest
grates75429892gr_ates_
gravest114011632gr_avest
grayest11489362gr_ayest
greases84816712greases_
greasiest10208562greasiest
greaten83610642greate_n
greatens9307592greatens
greater84416492greate_r
greatness1036902greatness
greats76318392great_s_
greaves113311442greaves_
greenest9312622greenest
greyest11348342gre_yest
iratest7312482ir_atest
neatest72516002_neatest
pretest9517632pre_test
realest73322432_realest
retest64028452_re_test
adeptest1145453adeptest
aerates74627493aerates_
alertest8310173alertest
arbalest1039523arbalest
aretes64425353are_tes_
berates94126873berates_
bleakest1436283bleakest
bravest124211753br_avest
brawest123810483br_awest
breast8319633brea__st
breathes134212903breathes_
breathiest1545993breathiest
breaths124411183breaths_
broadest1138573broadest
cerates95428253cerates_
cheapest1536073cheapest
cleanest10310293cleanest
clearest1038653clearest
crates85736063cr_ates_
creakiest15238593creakiest
creamiest13248933creamiest
creases94020963creases_
creasiest11229943creasiest
create85126383create__
created104323453create_d
cremates124216003cremates_
crepiest12310383crepiest
deadest93014883_deadest
deafest112911513_deafest
dearest83618673_dearest
deftest112611713_deftest
derates84028893derates_
detest74122843_de_test
directest1246303directest
dreamiest12227223dreamiest
dreariest10229123dreariest
ergates8314493ergates_
fleetest1136723fleetest
freakiest16206693freakiest
freest95318283fre__est
freshest143010583freshest
frettiest1267063frettiest
gamest94919923g__amest
gates65939513g__ates_
gauntest936603gauntest
gayest104314333g__ayest
geekiest13257863geekiest
geest64829613g_e__est
gelates83219583gelates_
gentes75324163g_entes_
gentlest93410573g_entlest
germiest11249913germiest
gestes75721393g_estes_
gjetost1543223gje_tost
gleamiest1235303gleamiest
gleetiest1035913gleetiest
graces94523493gr_aces_
gradates10510783gradates_
grades84926313gr_ades_
grandest10311573grandest
grapes95123123gr_apes_
grapiest112211923grapiest
grate64932883gr_ate__
grated84523923gr_ate_d
grater74625443gr_ate_r
graters85419743gr_aters
gratis74819243gr_atis_
graves104624003gr_aves_
grazes164519643gr_azes_
grease75416233grea__se
greased93812393grease_d
greaser83913083grease_r
greasers93410253greasers
greasy10419463grea__sy
great66034243grea___t
greatcoat1253343greatcoat
greatened1144583greatened
greatly1137613great_ly
greave104611493greave__
greaved12408913greave_d
grebes93813613gre_bes_
greediest1147553greediest
greeniest1039033greeniest
grees65132473gre__es_
greet65835323gre__e_t
greeted93111383greete_d
greeter82812673greete_r
greeters92610113greeters
greets75117423greet_s_
greiges937733greiges_
grenades1038433grenades_
greyness1235243greyness
grimiest11299823grimiest
grimmest13286293grimmest
gripiest11289633gripiest
grittiest10176983grittiest
groats74816653groat_s_
grodiest10310553grodiest
grossest93810093grossest
grottiest10147183grottiest
groutiest10147763groutiest
gruffest1544593gruffest
grummest13286363grummest
gyrates113610263gyrates_
ideates8313733ideates_
latest63822703__latest
leanest7415863_leanest
leftest10269463_leftest
meanest9315703_meanest
meatiest102816793_meatiest
nearest73415843_nearest
oleates7417833oleates_
orates64328613or_ates_
peartest10311303_peartest
peatiest103118803_peatiest
pertest9317043_pertest
prates84633163pr_ates_
predates11615813predates_
prelates10418573prelates_
pretests10310013pre_tests
pretext1639663pre_text
prettiest1199803prettiest
privatest14196733privatest
protest9317533pr_otest
rarest65725483_r_arest
rates55352013_r_ates_
rawest93615063_r_awest
readiest93719043_readiest
reagent8716603_reagent
reales64934123_reales_
realist73225383_realist
rearrest8311603_rearrest
reatas64021013_reatas_
reaves94127573_reaves_
rebates95123183_rebates_
redates83423873_redates_
reddest9311953_reddest
reest54938093_re__est
relates73731433_relates_
remates93827113_remates_
remotest103310723_remotest
renest64529713_re_nest
rentes65431193_rentes_
request16311023_request
retests73813853_re_tests
revest94623603_re_vest
searest73322023_searest
sedatest9249393sedatest
sveltest1135873sveltest
sweatiest1238413sweatiest
sweetest1137173sweetest
treated83618703treate_d
treater74219833treate_r
treaters83615843treaters
treaties8316983treaties_
treatise8311103treatise
treatment1148183treatment
treats64821693treat_s_
tritest7315273tr_itest
urates65027763ur_ates_
urbanest10117533urbanest
ureases74416723ureases_
weakest1439003_weakest
wettest10239363_wettest
wreathes14299893wreathes_
wreaths13338373wreaths_

Search took 9 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.1531167915.0
2DLD Change Limit1461621878.66016877.8
3Display Results1871870.0603116.7
 (SQL Overall)1786911878.87320138.7
 
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.