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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

103 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
groping11331310(None) 
griping113012061griping
grouping12308531grouping
growing123512471growing
roping94023021_roping
broking143514822broking
cooping123918932cooping
coping113927662_coping
craping124018712craping
creping122913652creping
cropping153210882cropping
crowing133814762crowing
doping103919462_doping
draping114213352draping
droning93013722droning
drooping12268802drooping
dropping14309282dropping
droving12379682droving
eloping103512832eloping
eroding9314272eroding
galoping1258022galoping
gaoling93314652gaoling
gaping105618922g_aping
gapping134214782gapping
garoting10510702garoting
gasping113714362gasping
gawping14418462gawping
gimping133710762gimping
gipping133813122gipping
globing113210002globing
glopping14307752glopping
gloving12308442gloving
glowing123211792glowing
glozing18338892glozing
going75218492g_o_ing
goofing123510632goofing
goosing93314082goosing
gorging102611362gorging
goring84119572g_oring
gorming112810832gorming
gracing113216442gracing
grading103918712grading
graphing1538532graphing
grasping12348832grasping
grating93923182grating
graving123114562graving
graying124115882graying
grazing183514552grazing
greeing93613782greeing
greying124110892greying
griding103014972griding
griming113612492griming
gripping14277542gripping
groaning102410282groaning
groin65521082gro_in_
groining102310632groining
groins73917202gro_ins
grokking1334812grokking
grooming12309512grooming
grooving13286712grooving
gropingly1644852gropingly
grossing103111062grossing
groupings13273812groupings
grousing103410452grousing
grouting103410792grouting
growling1348162growling
grumping14266902grumping
gulping11309752gulping
gypping16305842gypping
hooping133615702hooping
hoping123719742_hoping
ironing82414012ironing
looping103615282looping
loping93921412_loping
moping114017102_moping
oping86322412__oping
pooping123615442pooping
probing123314442probing
propine113020212propine
propping122811672propping
prosing103319382prosing
proving134214072proving
raping94829852_raping
riping93821612_riping
robing93618002_robing
romping123113032_romping
rosing73925592_rosing
rouping103715792_rouping
roving103618742_roving
rowing103623302_rowing
scoping123513822scoping
sloping104114072sloping
stoping103716622stoping
toping94122992_toping
troking123514102troking
tromping13319602tromping
trooping112710282trooping
tropin83316752tropin_
tropine93116652tropine
tropins93116312tropins
trouping11249502trouping
trowing113413702trowing
urping93914052ur_ping

Search took 4 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 Filter1786911076710.356501941.0
2DLD Change Limit1076711033.40631612.2
3Display Results1031030.0333121.2
 (SQL Overall)1786911033.79547085.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.