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

161 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
greasiest1020856(None) 
creasiest11229941creasiest
creakiest15238592creakiest
creamiest13248932creamiest
dreamiest12227222dreamiest
dreariest10229122dreariest
dressiest1036822dressiest
easiest72318772__easiest
freakiest16206692freakiest
gleamiest1235302gleamiest
grapiest112211922gr_apiest
grassiest10309512grassiest
greases84816712greas_es_
greasier9298082greasie_r
greasiness1156532greasiness
greatest939862grea_test
greediest1147552greediest
greeniest1039032greeniest
queasiest1844312queasiest
readiest93719042_readiest
tressiest937882tressiest
uneasiest946562uneasiest
artsiest879653ar_tsiest
beadiest113815533_beadiest
beakiest143313463_beakiest
beamiest123212763_beamiest
bleariest1158843bleariest
brakiest143912243br_akiest
brashest133511763br_ashest
brashiest14359853br_ashiest
brassiest11369713brassiest
breathiest1545993breathiest
breeziest2035063breeziest
cheesiest1436323cheesiest
crassest103411523cr_assest
craziest19319923cr_aziest
creases94020963creas_es_
creasier103210193creasie_r
creepiest1337063creepiest
crepiest12310383cre_piest
croakiest15167173croakiest
drearies92313413drearies_
dreggiest12124543dreggiest
drossiest1036523drossiest
drowsiest1334993drowsiest
easies64126633__easies_
freshest143010583fre_shest
frettiest1267063frettiest
frowsiest1535063frowsiest
gamiest102816223g__amiest
gashest114813413g__ashest
gassiest93212523g_assiest
geekiest13257863g_eekiest
gemmiest13227623g_emmiest
germiest11249913g_ermiest
gladiest101710333g_ladiest
glariest92012523g_lariest
glassiest10279243glassiest
glaziest18227913g_laziest
gleetiest1035913gleetiest
glossiest10277943glossiest
goosiest92911823g_oosiest
gorsiest92511133g_orsiest
grabbiest1435323grabbiest
gradient10310373gr_adient
grainiest10188993grainiest
grandest10311573gr_andest
grasses84117343gr_asses_
gravest114011633gr_a_vest
gravies11314093gr_avies_
grayest11489363gr_a_yest
grease75416233greas_e__
greased93812393greas_e_d
greaseless1143483greaseless
greaser83913083greas_e_r
greasers93410253greas_ers
greasily1236233greasi_ly
greasing102811393greasi_ng
greatness1036893greatness
greaves113311443grea_ves_
greenest9312623gre_enest
greenies9312673greenies_
gremmies1355993gremmies_
grewsomest1651813grewsomest
greyest11348343gre__yest
grimiest11299823gr_imiest
gripiest11289633gr_ipiest
grippiest1435143grippiest
grisliest1047353grisliest
grittiest10176983grittiest
grodiest10310553gr_odiest
groggiest1235093groggiest
grooviest1334083grooviest
grossest93810093gr_ossest
grottiest10147183grottiest
groutiest10147763groutiest
growliest1335583growliest
grubbiest1434253grubbiest
gruffiest1634523gruffiest
grumpiest1435023grumpiest
grungiest1135803grungiest
gutsiest92610583g_utsiest
headiest123015553_headiest
heaviest143210443_heaviest
leadiest93314983_leadiest
leafiest113410883_leafiest
leakiest123212793_leakiest
leariest83117843_leariest
leaviest112910813_leaviest
mealiest102215973_mealiest
measliest1147173_measliest
meatiest102816793_meatiest
messiest103112423_messiest
newsiest11107483_newsiest
peakiest143512993_peakiest
peatiest103118803_peatiest
preachiest1746983preachiest
precisest13259003precisest
preppiest1236973preppiest
prettiest1199803prettiest
prissiest11178903prissiest
prosiest10416523pr_osiest
queaziest2743243queaziest
raciest92820013_r_aciest
rashest103916873_r_ashest
raspiest10311273_r_aspiest
readies83324713_readies_
realest73322433_rea_lest
realist73225383_reali_st
rearrest8311603_rearrest
reascent10411983_reascent
reassert8313673_reassert
reassess836513_reassess
reediest92815423_reediest
reefiest112811483_reefiest
reekiest122711313_reekiest
resist64524533_re_si_st
rosiest73919213_r_osiest
seamiest102715413_seamiest
sleaziest1836053sleaziest
smeariest1138113smeariest
sneakiest13176823sneakiest
steadiest1038513steadiest
steamiest1138403steamiest
streakiest1444763streakiest
streamiest1245113streamiest
sweatiest1238413sweatiest
teariest82417263_teariest
teensiest945823teensiest
threadiest1444283threadiest
trashiest123110633tr_ashiest
treacliest1245383treacliest
treaties8316983treaties_
trendiest1038423trendiest
tweakiest1634053tweakiest
unreadiest1144803unreadiest
ureases74416723ureas_es_
vealiest112513203_vealiest
weariest112914793_weariest
weensiest1244743weensiest
yeastiest1237203_yeastiest

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411618.09318366.6
3Display Results1611610.0632555.6
 (SQL Overall)1786911618.31221498.0
 
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.