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

108 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
grapy11541643(None) 
gapy106320911g_apy
grape84824661grape
grapey126012301grapey
graph115315611graph
gravy125512111gravy
gray85329891gra_y
gripy115115251gripy
braky145015812braky
braxy175410892braxy
bray95232902bra_y
crampy154710992crampy
crap85731842crap_
crape96128442crape
crappy15446802crappy
craps95328642craps
crazy195511222crazy
crepy124812702crepy
drape85319632drape
drapey125010582drapey
dray85428092dra_y
frap95925812frap_
fraps105620552fraps
fray105428902fra_y
gaby107123192g_aby
gamy105427532g_amy
gap67055612g_ap_
gape75134512g_ape
gappy136212032gappy
gaps76042972g_aps
gay76856492g_a_y
gimpy135212232gimpy
glady105413942glady
glary96018542glary
glazy187410982glazy
goopy115816622goopy
graal64316502graal
grab75427612gra_b
grabby14336182grabby
grabs85719692grabs
grace85124542grace
grad66829862gra_d
grade75126092grade
grads75625752grads
graft95327202graft
grail64622872grail
grain65126252grain
grainy103914212grainy
gram77034582gra_m
grama85620282grama
gramp106218322gramp
grampa115010172grampa
gramps114114272gramps
grams85327312grams
gran56335012gra_n
grana65722092grana
grand75122692grand
granny104311162granny
grans64832542grans
grant64840022grant
grapery13457952grapery
grapes95123122grapes
graphs124510152graphs
grappa11396442grappa
grasp84814482grasp
grasps9489252grasps
grass66125202grass
grassy10619092grassy
grat55651282gra_t
grate64932882grate
grave94624872grave
grayly13287962grayly
grays95621332grays
graze155820052graze
greasy10419462greasy
grey85624042gr_ey
grimy114312602grimy
grip76127022grip_
gripe84622962gripe
gripey124111202gripey
grippy14447762grippy
grips85520132grips
gript85126172gript
grody103412062grody
grope84821612grope
grumpy14498152grumpy
gulpy114612762gulpy
guppy135211272guppy
harpy136418202harpy
heapy135914982heapy
pray96331532pra_y
racy95825682_racy
rap56261962_rap_
rape65041632_rape
raps66247732_raps
rapt67245312_rapt
raspy106511702_raspy
ray66361992_ra_y
ropy96323412_ropy
soapy106114782soapy
trampy13499252trampy
trap67532802trap_
traps75727482traps
trapt76433392trapt
tray77632592tra_y
wrap96821972wrap_
wraps105617152wraps
wrapt105123182wrapt

Search took 2 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.0931921408.6
2DLD Change Limit538001081.83029398.9
3Display Results1081080.0303600.0
 (SQL Overall)1786911081.95391495.6
 
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.