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

98 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
grasp8481448(None) 
gasp76227331g_asp
gramp106218321gramp
grasps9489251grasps
grass66125201grass
rasp66029161_rasp
asp57235342__asp
bras65746452bras_
brash106221562brash
brass75428022brass
clasp95517192clasp
cramp115120692cramp
crap85731842cra_p
craps95328642craps
crash109120012crash
crass76328042crass
crisp95014622crisp
eras45441502eras_
erase54925492erase
frap95925812fra_p
fraps105620552fraps
frass85321122frass
gamp98833212g_amp
gap67055612g_a_p
gaps76042972g_aps
gars55750742gars_
gas48870252g_as_
gash86833022g_ash
gasps85415482g_asps
gast56052562g_ast
gawp107618632g_awp
ghast95621222ghast
glass65518132glass
gnash9449832gnash
goas55239942goas_
graal64316502graal
grab75427612gra_b
grabs85719692grabs
grace85124542grace
grad66829862gra_d
grade75126092grade
grads75625752grads
graft95327202graft
grail64622872grail
grain65126252grain
gram77034582gra_m
grama85620282grama
grampa115010172grampa
gramps114114272gramps
grams85327312grams
gran56335012gra_n
grana65722092grana
grand75122692grand
grans64832542grans
grant64840022grant
grape84824662grape
graph115315612graph
grappa11396442grappa
grapy115416432grapy
grasped11409062grasped
grasper10389782grasper
grassy10619092grassy
grat55651282gra_t
grate64932882grate
grave94624872grave
gravy125512112gravy
gray85329892gra_y
grays95621332grays
graze155820052graze
grease75416232grease
greasy10419462greasy
grip76127022gr_ip
grips85520132grips
grist65529872grist
gross65421692gross
grosz154814092grosz
group85413922group
grump105115312grump
gyrase10508772gyrase
hasp96627292_hasp
prase76128752prase
ramp85934002_ramp
rap56261962_ra_p
raps66247732_raps
ras37575392_ras_
rase46149982_rase
rash76039932_rash
rasps74316662_rasps
raspy106511702_raspy
tramp96319772tramp
trap67532802tra_p
traps75727482traps
trash86119762trash
trass56226472trass
urase54624682urase
wasp95626852_wasp
wrap96821972wra_p
wraps105617152wraps

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.186960704.3
2DLD Change Limit53800983.90613773.7
3Display Results98980.0462130.4
 (SQL Overall)178691984.13843182.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.