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

175 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
grossest9381009(None) 
crossest1012012121crossest
grosses84517681grosses_
crassest103411522crassest
crosses94220792crosses_
drosses84513822drosses_
drossiest1036522drossiest
glosses84014122glosses_
glossiest10277942glossiest
goosiest92911822goosiest
gorsiest92511132gorsiest
grasses84117342grasses_
grassiest10309512grassiest
grodiest10310552grodiest
grossed93812252grosse_d
grosser84313142grosse_r
grossers94410972grossers
grossness1045962grossness
grouses84616542grouses_
prosiest10416522prosiest
prosses94019512prosses_
rosiest73919212_rosiest
arouses74921293arouses_
artsiest879653artsiest
bosses85925403_bosses_
bossiest103112213_bossiest
brashest133511763brashest
brasses93818353brasses_
brassiest11369713brassiest
briskest14337803briskest
brisses94314313brisses_
broadest1138573broadest
broses86524403bro_ses_
brownest1398893brownest
browses124712693browses_
bruskest14315903bruskest
closest94312533clo_sest
cosiest93819853_cosiest
cosset84125863_cosse_t
cossets95014283_cossets
cresses94219813cresses_
cresset93319943cresse_t
cressets10309103cressets
crispest12177373crispest
crookest1436683crookest
crosscut1245253crosscut
crosse85216303crosse__
crossed105313893crosse_d
crosser95015463crosse_r
crossers103912693crossers
crosslet1049593crosslet
crosslets1145183crosslets
crossness1137093crossness
dosses76126273_dosses_
dresses83716173dresses_
dressiest1036823dressiest
drollest937353drollest
drowses114610233drowses_
drowsiest1334993drowsiest
egresses949443egresses_
engrosses1045473engrosses_
eroses65327053ero_ses_
flosses103411973flosses_
flossiest12296803flossiest
fosses96022083_fosses_
frasses104314513frasses_
freshest143010583freshest
frostiest1239213frostiest
frowsiest1535063frowsiest
gashest114813413g_ashest
gasses75724783g_asses_
gassiest93212523gassiest
gausses8308693gausses_
ghostiest1336543ghostiest
glasses84414273glasses_
glassiest10279243glassiest
glossas8438193glossas_
glossed94410073glosse_d
glosseme1144023glosseme
glosser83410813glosse_r
glossers9319053glossers
glossies93311253glossies_
gnoses76515163gno_ses_
goldest92411173g_oldest
goofiest12289393goofiest
gooiest82813883g_ooiest
gooniest93213003gooniest
goopiest112710553goopiest
gooses75723053g_ooses_
goriest82218743g_oriest
gorses74723293g_orses_
grandest10311573grandest
grapiest112211923grapiest
grassed93812793grasse_d
grassless1034303grassless
gravest114011633gr_avest
grayest11489363gr_ayest
greases84816713greases_
greasiest10208563greasiest
greatest939863greatest
greenest9312623greenest
greyest11348343gr_eyest
grilses8319153grilses_
grimiest11299823grimiest
grimmest13286293grimmest
gripiest11289633gripiest
grisliest1047353grisliest
groggiest1235093groggiest
grommet12268453gromme_t
grommets13234663grommets
grooves11368803grooves_
grooviest1334083grooviest
gropes95220403gro_pes_
grosbeak1542543grosbeak
gross65421693gro_s_s_
grossing103111063grossing
grossly1175983gross_ly
grosze16457733grosze__
grottiest10147183grottiest
grouse74315023grouse__
groused94712833grouse_d
grouser84513693grouse_r
grousers93810723grousers
groutiest10147763groutiest
groves104318103gro_ves_
growliest1335583growliest
groynes1137823groynes_
gruffest1544583gruffest
grummest13286363grummest
guesses8169373guesses_
gusset7316433g_usse_t
gussets837443g_ussets
gutsiest92610583gutsiest
horsiest112513263horsiest
josses135117683_josses_
karosses1236493karosses_
loosest75811563_loosest
losses65925233_losses_
mosses85527683_mosses_
mossiest103112443_mossiest
mostest9314793_mostest
nosiest73415673_nosiest
ogresses938473ogresses_
poshest12312423_poshest
posses85128803_posses_
possess9419113_possess
posset84923253_posse_t
possets94212773_possets
presses93523153presses_
prisses94816713prisses_
prissiest11178903prissiest
prosaist10611583prosaist
prosect11313393pro_sect
proses84733473pro_ses_
prospect1447893prospect
prossies101515223prossies_
protest9317533pro_test
proudest1138943proudest
prowest12311533pro_west
rashest103916873_rashest
rooses65526233_rooses_
ropiest93317773_ropiest
roses56445773_ro_ses_
roset55945243_ro_se_t
rosets65819953_ro_sets
rouses65436283_rouses_
russet6319433_russe_t
russets738163_russets
tosses65225393_tosses_
trasses74819323trasses_
tresses73719543tresses_
tressiest937883tressiest
trusses73813633trusses_
wrasses103812593wrasses_
wrongest1236733wrongest

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.1561145455.1
2DLD Change Limit1461621758.61016975.8
3Display Results1751750.0632777.8
 (SQL Overall)1786911758.82920239.1
 
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.