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

105 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
groupings1327381(None) 
grouping12308531grouping_
droppings15264502droppings
groping113313102gro_ping_
groundings1343742groundings
groupies1137522groupi_es
grousing103410452grousing_
grouting103410792grouting_
rouping103715792_rouping_
trouping11249502trouping_
arousing93811803arousing_
brokings15317713bro_kings
bronzings2143643bronzings
copings124111843_co_pings
couping124317023_couping_
couplings1435543_couplings
cropping153210893cropping_
crossings12217163crossings
croupiers1334653croupiers
dopings11408783_do_pings
drippings15313903drippings
drooping12268803drooping_
dropping14309283dropping_
drouking1436443drouking_
foulings12327943_foulings
frostings1335733frostings
ghostings1433483ghostings
gloamings13254093gloamings
gloomings13283973gloomings
glopping14307753glopping_
glouting10379693glouting_
godlings11367493g_odlings
goings84911523g_o__ings
golfings13304873g_olfings
goslings10297553g_oslings
gouging103410703g_ouging_
grapplings1642323grapplings
grasping12348833grasping_
gratings103910763gr_atings
graylings1433883graylings
grazings19337263gr_azings
greenings11266663greenings
greetings11276043greetings
griping113012063gr_iping_
gripping14277543gripping_
groaning102410283groaning_
groining102310633groining_
groins73917203gro__in_s
grokking1334813grokking_
grooming12309513grooming_
grooving13286713grooving_
gropingly1644853gro_pingly
grossing103111063grossing_
grouching1644943grouching_
grounding1236083grounding_
groundlings1442073groundlings
grounds9228313grou__nds
groupers11358643group_ers
groupie1045783groupi__e
groupoids1342463groupoids
groups94210513group___s
groupthinks215683groupthinks
growing123512473gro_wing_
growling1348163growling_
gruelings1163763gruelings
grumping14266903grumping_
hoppings16306523_hoppings
housings12307483_housings
ironings9217583iro_nings
louping104313983_louping_
mousings11277703_mousings
outings84014753__outings
propines122618933pro_pines
propping122811673propping_
raspings11337853_raspings
regrouping1443693regrouping_
roarings9248293_roarings
rollings9419953_rollings
romping123113033_romping_
roofings12256023_roofings
roping94023023_ro_ping_
rouging93114703_rouging_
rousing83920553_rousing_
routines82214363_routines
routing83821093_routing_
rovings11439493_ro_vings
rowings113710363_ro_wings
rulings83310383_r_ulings
scourings12235293scourings
scoutings12306143scoutings
shoppings17295073shoppings
souping104215533_souping_
spoutings12245153spoutings
stroudings1242743stroudings
toppings13286423_toppings
tourings9277373_tourings
trappings14265753trappings
trippings14225723trippings
trollings10286693trollings
tromping13319603tromping_
trooping112710283trooping_
tropines102214923tro_pines
tropins93116313tro_pin_s
troupials1142933troupials
wrappings17253713wrappings

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.420425454.8
2DLD Change Limit1486411058.47017549.1
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.93619996.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.