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

116 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
grooviest133408(None) 
broodiest1237822broodiest
broomiest1356912broomiest
drooliest1036342drooliest
droopiest1235742droopiest
gloomiest1235602gloomiest
goofiest12289392g_oofiest
gooiest82813882g_oo_iest
gooniest93213002g_ooniest
goopiest112710552g_oopiest
goosiest92911822g_oosiest
grodiest10310552gr_odiest
groggiest1235092groggiest
grooves11368802groov_es_
groovier1233792groovie_r
grottiest10147182grottiest
groutiest10147762groutiest
growliest1335582growliest
rookiest122912172_rookiest
roomiest102611992_roomiest
rootiest83115592_rootiest
bloodiest1236663bloodiest
bloomiest1335853bloomiest
boomiest122711843_boomiest
booziest19379263_booziest
bronziest2035813bronziest
brookies1459143brookies_
browniest14207123browniest
choosiest1437323choosiest
croakiest15167173croakiest
crookest1436683croo_kest
croupiest1337053croupiest
doomiest112910453_doomiest
drossiest1036523drossiest
drowsiest1334993drowsiest
footiest113514913_footiest
froggiest1434913froggiest
frostiest1239213frostiest
frothiest1537453frothiest
frouziest2143973frouziest
frowsiest1535063frowsiest
frowziest2443483frowziest
ghostiest1336543ghostiest
globbiest1444023globbiest
gloppiest1444823gloppiest
glossiest10277943glossiest
godliest1039453g_odliest
goodies93516993g_oodies_
goodliest1146393goodliest
goonies83618333g_oonies_
goriest82218743g__oriest
gorsiest92511133g_orsiest
goutiest93013883g_outiest
grabbiest1435323grabbiest
grainiest10188993grainiest
grapiest112211923gr_apiest
grassiest10309513grassiest
gravest114011633gr_av_est
gravies11314093gr_avies_
greasiest10208563greasiest
greediest1147553greediest
greeniest1039033greeniest
grimiest11299823gr_imiest
gripiest11289633gr_ipiest
grippiest1435143grippiest
grisliest1047353grisliest
grittiest10176983grittiest
groove10438873groov_e__
grooved12347253groov_e_d
groover11358543groov_e_r
groovers12337123groov_ers
grooving13286713groovi_ng
grossest93810093gr_ossest
grouchiest1644123grouchiest
groupies1137523groupies_
groves104318103gr_ov_es_
growthiest1742883growthiest
grubbiest1434253grubbiest
gruffiest1634523gruffiest
grumpiest1435023grumpiest
grungiest1135803grungiest
hoodiest122413173_hoodiest
hookiest152712103_hookiest
hootiest113115643_hootiest
kookiest11268133_kookiest
looniest83313253_looniest
loopiest103011313_loopiest
moodiest112712183_moodiest
mooniest103014173_mooniest
mooriest102812723_mooriest
ooziest163411523__ooziest
priviest132310313pr_iviest
prosiest10416523pr_osiest
rockiest142912223_rockiest
roiliest8312283_roiliest
roofies103014413_roofies_
rookies113917103_rookies_
roomies93017243_roomies_
ropiest93317773_r_opiest
rosiest73919213_r_osiest
roupiest102610293_roupiest
rowdiest12259213_rowdiest
snoopiest11157053snoopiest
snootiest9178743snootiest
snooziest18175383snooziest
sootiest84016753_sootiest
spookiest15156393spookiest
spooniest11178133spooniest
swooniest12176293swooniest
swoopiest14155383swoopiest
troutiest9127803troutiest
woodiest123112073_woodiest
wooliest113011643_wooliest
wooziest20327903_wooziest
zooiest16199923_zoo_iest
zootiest173311213_zootiest

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.1731032896.0
2DLD Change Limit1486411168.12318298.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.34221420.6
 
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.