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

74 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
group8541392(None) 
croup95616781croup
groups94210511groups
grout65330421grout
roup66627691_roup
coup86729792_coup
crop87628632cro_p
croupe105114432croupe
croups104312552croups
croupy13458732croupy
droop85814822droop
drop75324402dro_p
drouk1039432drouk
getup83410262getup
ghoul959052ghoul
glop76724632glo_p
glout65925812glout
goop75829482g_oop
gorp75625902g_orp
gout56646002g_out
gramp106218322gramp
grasp84814482grasp
grip76127022gr_ip
groan65618422groan
groat65531972groat
grody103412062grody
grog65923342gro_g
grogs76319412grogs
groin65521082groin
grok95819682gro_k
groks105716122groks
groom85317982groom
grope84821612grope
gross65421692gross
grosz154814092grosz
grot55942052gro_t
grots65025852grots
grouch12318472grouch
ground82310272ground
grouped11419192grouped
grouper104210092grouper
groupie1045782groupie
grouse74315022grouse
grouts75015612grouts
grouty104710982grouty
grove95219332grove
grow86127302gro_w
growl96115822growl
grown95317352grown
grownup1342212grownup
grows95523922grows
grub77220082gr_ub
grue55825712gr_ue
grum75625082gr_um
grump105115312grump
ingroup1044332ingroup
loup66028432_loup
prop85932812pro_p
proud84615482proud
regroup1095172regroup
romp85926572_romp
roue45941742_roue
roups75118902_roups
roupy106112712_roupy
rout46153282_rout
roux117419362_roux
soup66232912_soup
stoup75517072stoup
tromp95815802tromp
troop76417532troop
trop66833302tro_p
troupe84812432troupe
trout57332572trout
vrouw11507342vrouw

Search took 5 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 Filter178691538000.326548131.9
2DLD Change Limit53800743.73614400.4
3Display Results74740.0164625.0
 (SQL Overall)178691744.07843818.3
 
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.