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

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

107 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
graperies123961(None) 
draperies1249191draperies
aperies9423202__aperies
braveries1439102braveries
draperied1344982draperied
gramaries12128312gramaries
gramercies1544042gramercies
granaries10159882granaries
grapevines1642902grapevines
groceries1249512groceries
japeries17311462_japeries
naperies10313902_naperies
roperies10315772_roperies
traceries11312862traceries
aeries64737783__a_eries
archeries14411223archeries
arteries8321513ar_teries
bakeries14312203_bakeries
beaneries11310903beaneries
brasseries1246873brasseries
breweries1447583breweries
briberies1348343briberies
cooperies131113323cooperies
crappies142911173crap_pies
creameries1446673creameries
deaneries10310833deaneries
dramedies1345123dramedies
drapers105313353draper__s
duperies11312813_duperies
eateries8324323_eateries
emperies12314563_emperies
faeries104118993_fa_eries
fakeries1559833_fakeries
flaneries1249563flaneries
fopperies1666023fopperies
fripperies1743593fripperies
gaieties9310183g_aieties
galeres83514343g_aler_es
galleries10311713galleries
gantries91413803g_antries
gapers94520473g_aper__s
gauderies1147743gauderies
gayeties1236883g_ayeties
gharries12318223gha_rries
glazieries2043583glazieries
graders94716013grader__s
graecizes2144573gra_ecizes
gramaryes1572883gramaryes
grannies9312613gra_nnies
grapefruits176823grapefruits
grapelike1644663grapelike
grapery13457953graper__y
grapes95123123grap___es
grapevine1543243grapevine
graphemes1743633graphemes
graphemics2052583graphemics
graphics1645653grap_hics
graphites1546823graphites
grapier103712603grap__ier
grapiest112211933grap__iest
graplines1237353graplines
graplins1148263grap_lins
grapples13348123grap_ples
graspers11338403grasper__s
graters85419743grater__s
gratifies1347993gratifies
gravers114515273graver__s
gravesides1543743gravesides
gravesites1443943gravesites
gravies11314093gra__vies
gravities1338303gravities
gravures1234903gravur_es
grazers175112453grazer__s
greeneries1167083greeneries
greenies9312673gr_eenies
grilleries1145593grilleries
grinderies1245853grinderies
gripers104011463griper__s
groggeries1354713groggeries
gropers104813853groper__s
gruyeres1242863gruyer_es
gunneries1047043gunneries
imageries1246783imageries
knaveries1645013knaveries
moperies12313873_moperies
orangeries11116943orangeries
oratories9410653oratories
orreries8310123or_reries
poperies12316793_poperies
prairies10411463pra_iries
properties141411893properties
pruderies1247873pruderies
rapers84327183_raper__s
rarefies1138993_rarefies
rareripes1165353_rareripes
reveries112518513_reveries
roseries8317323_roseries
ruderies9311333_ruderies
sealeries9313133sealeries
slaveries1249693slaveries
traceried1247143traceried
tragedies1146523tragedies
trapeses1039153trape_ses
trapezes1936543trape_zes
trapezius2043343trapezius
traverses1246343traverses
trumperies1444453trumperies

Search took 10 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 Filter1786911486410.873204686.1
2DLD Change Limit1486411078.12618292.0
3Display Results1071070.0462326.1
 (SQL Overall)1786911079.04519755.8
 
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.