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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
grossness104596(None) 
crossness1137091crossness
crassness1136212crassness
glossiness11284982glossiness
grassless1034302grassless
grossers94410972gross_ers
grosses84517682gross_e_s
grossest93810092gross_est
grossnesses1146712grossnesses
prosiness11311682prosiness
rosiness82613172_rosiness
artsiness937653artsiness
bassness1096743_bassness
bossiness11257423_bossiness
brashness1436323brashness
brassiness1235483brassiness
briskness1544763briskness
broadness1256663broadness
brownness1444343brownness
closeness1137613closeness
cosiness103214283_cosiness
crispness1345303crispness
crossers103912703cross_ers
crosses94220793cross_e_s
crossest1012012123cross_est
crosslets1145183crosslets
crossnesses1247123crossnesses
dressiness1145543dressiness
drollness1043623drollness
drosses84513823dross_e_s
drossiest1036523drossiest
drowsiness1443643drowsiness
freshness1545943freshness
frostiness1336563frostiness
frostless1235743frostless
garishness1445743garishness
gassiness10268313gassiness
gastness9278473g_astness
glassiness11245993glassiness
glassless1043873glassless
glossers9319053gloss_ers
glosses84014123gloss_e_s
glossies93311253glossie_s
glossiest10277943glossiest
goneness9310763g_oneness
goodness1036253g_oodness
gooeyness1343543gooeyness
goofiness1365603goofiness
goriness9310753g_oriness
grandness1138303grandness
grapiness1238253grapiness
grasses84117343grass_e_s
grassiest10309513grassiest
graveness13288383graveness
grayness1235933gr_ayness
greasiness1156543greasiness
greatness1036903greatness
greenness1046793greenness
greyness1235243gr_eyness
griminess1236703griminess
grimness1175993gr_imness
grisliness1155143grisliness
groaners9248503gro_aners
grogginess1343413grogginess
grossed93812253gross_e_d
grosser84313143gross_e_r
grousers93810733grous_ers
grouses84616543grous_e_s
groveless13235363groveless
growliness1494073growliness
groynes1137823gro_yne_s
gruffness1692743gruffness
gutsiness10226963gutsiness
horsiness12259473horsiness
ironness836953iro_nness
looseness937473looseness
lossless835473_lossless
lostness837683_lostness
moroseness1246213moroseness
mossiness11258323_mossiness
nosiness83211393_nosiness
piousness1147633piousness
porousness1248443porousness
poshness1356653_poshness
possess9419123_poss_ess
prissiness1266133prissiness
proneness11310443proneness
prosses94019513pross_e_s
prossies101515223prossie_s
proudness1246693proudness
rashness1138093_rashness
ropiness102311073_ropiness
wrongness1344513wrongness

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.1601116818.8
2DLD Change Limit148641938.01318550.0
3Display Results93930.0462021.7
 (SQL Overall)178691938.21921741.2
 
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.