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

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

70 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
groups9421051(None) 
croups104312551croups
group85413921group_
grouts75015611grouts
roups75118901_roups
coups95522472_coups
crops96125232cro_ps
croup95616782croup_
croupe105114432croupe
croupes114613102croupes
croupy13458732croupy
droops95110962droops
drops85719502dro_ps
drouks1137122drouks
getups9346852getups
ghouls1036042ghouls
glops85619552glo_ps
glouts74414712glouts
goops86620962g_oops
gorps85316992g_orps
gouts64826172g_outs
gramps114114272gramps
grasps9489252grasps
grips85520132gr_ips
groans74815062groans
groats74816652groats
grogs76319412gro_gs
groins73917202groins
groks105716122gro_ks
grooms94512522grooms
grope84821612gro_pe
gropes95220402gropes
gross65421692gro_ss
grots65025852gro_ts
grouch12318472grouch
ground82310272ground
grounds9228312grounds
grouped11419192grouped
grouper104210092grouper
groupers11358642groupers
groupie1045782groupie
groupies1137522groupies
grouse74315022grouse
grouses84616542grouses
grout65330422grou_t
grouty104710982grouty
groves104318102groves
growls104711112growls
grownups1441502grownups
grows95523922gro_ws
grubs86312602gr_ubs
grues65721962gr_ues
grumps114510572grumps
ingroups1143482ingroups
loups75319622_loups
props95726882pro_ps
regroups11104382regroups
romps94617542_romps
roues56039352_roues
roup66627692_roup_
roupy106112712_roupy
routs57133412_routs
soups75322942_soups
stoups85313272stoups
tromps104911702tromps
troops85712782troops
troupe84812432troupe
troupes94112852troupes
trouts66116632trouts
vrouws12494742vrouws

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit82551702.54632423.8
3Display Results70700.0332121.2
 (SQL Overall)178691702.93960799.9
 
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.