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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
gravelling156521(None) 
gavelling14286891g_avelling
graveling1457381grave_ling
grovelling1554161grovelling
ravelling13269261_ravelling
travelling1456531travelling
drivelling1543982drivelling
gaveling133410162g_ave_ling
groveling1435572grove_ling
gruelling1155602gr_uelling
marvelling1645362marvelling
raveling123414372_rave_ling
ravellings14214472_ravellings
revelling132412552_revelling
tramelling1346382tramelling
traveling1349052trave_ling
unravelling1543152unravelling
barrelling1345453barrelling
bevelling15227453_bevelling
brailling1247773bra_illing
cavilling1536393_cavilling
cravening1547553crave_ning
crenelling1345683crenelling
driveling1445763drive_ling
enamelling1344323enamelling
frivolling1742763frivolling
galling93921963g_a__lling
gavelkind18132153g_avelkind
gelling93219763g___elling
grabbling1564583gra_bbling
grappling1544993gra_ppling
gravelike1744513grave_like
gravelled1475553gravell_ed
gravelly15385773gravell__y
graving123114563grav___ing
grayling1338003gra__yling
greenling1136753gr_eenling
grilling103811533gr__illing
grueling1078273gr_ue_ling
gruellings1272323gr_uellings
hovelling1636163_hovelling
kvelling16146513__kvelling
labelling1238103_labelling
levelling13206983_levelling
marcelling1545593marcelling
marveling1537103marve_ling
panelling1239093_panelling
parcelling1546183parcelling
preselling1338693preselling
pretelling1338143pretelling
propelling1556933propelling
rappelling1544363_rappelling
ravelin102211023_rave_lin_
ravelings13377383_rave_lings
ravelins113011603_rave_lins
ravening122611293_rave_ning
rebelling122111163_rebelling
refelling132211313_refelling
repelling122312753_repelling
reselling102213833_reselling
retelling102112503_retelling
revealing132611883_revealing
reveling123117083_reve_ling
rivalling1335963_rivalling
rowelling1366993_rowelling
shaveling1646843shave_ling
shovelling1744063shovelling
shrivelling1842213shrivelling
snivelling1444293snivelling
swivelling1743413swivelling
teaselling1145333teaselling
teazelling2043803teazelling
trameling1249053trame_ling
trammelling1642613trammelling
travailing1444613travailing
traversing1444803traversing
trowelling1484913trowelling
unraveling1454473unrave_ling
weaselling1454233weaselling

Search took 8 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 Filter1786911406030.813219792.1
2DLD Change Limit140603796.67021079.9
3Display Results79790.0332393.9
 (SQL Overall)178691797.51623774.7
 
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.