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

161 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
gavelling1428687(None) 
gaveling133410161gave_ling
gravelling1565211gravelling
ravelling13269241ravelling
bevelling15227452bevelling
cavilling1536392cavilling
galling93921962ga__lling
gavelkind18132152gavelkind
gelling93219762g__elling
graveling1457382grave_ling
grovelling1554162grovelling
gruelling1155602gruelling
hovelling1636162hovelling
kvelling16146512_kvelling
labelling1238082labelling
levelling13206972levelling
marvelling1645362marvelling
panelling1239072panelling
raveling123414372rave_ling
ravellings14214452ravellings
revelling132412552revelling
travelling1456532travelling
aneling82719503_ane_ling
anvilling1336833anvilling
availing1267283_availing
avellan1037293_avellan_
avellane1146263_avellane
avenging1345863_avenging
averring12239063_averring
averting122512733_averting
avulsing1234433_avulsing
balling104424763ba__lling
barrelling1345453barrelling
belling103825073__belling
beveling143011033beve_ling
bowelling1566493bowelling
caballing1436883caballing
cageling12310843cage_ling
calling103826773ca__lling
canalling1239553canalling
cancelling1547213cancelling
capellini1345263capellini
carolling1259413carolling
caveating1539293caveating
caverning1536283caverning
caviling14310113cav_iling
celling103921263__celling
covelline1446533covelline
cupelling1436283cupelling
davening13258873dave_ning
develing133212733deve_ling
devilling1436703devilling
dowelling1466253dowelling
drivelling1543983drivelling
duelling103410733_duelling
dwelling13368413_dwelling
enamelling1344313enamelling
excelling1935643excelling
expelling1936133expelling
falling113621583fa__lling
felling113321133__felling
fuelling123410153_fuelling
gabbling14238073ga_bbling
gabling113514543ga__bling
gaeing84617223ga_e__ing
gaggling10217463ga_ggling
galleting1137633galleting
gallying13328933ga_llying
gambling14218963ga_mbling
gamboling1556133gamboling
gambolling1643443gambolling
gangling112411403ga_ngling
gaoling93314653ga__oling
garbling12249453ga_rbling
gargling11239203ga_rgling
gavelkinds19161263gavelkinds
gavelled13387363gavell_ed
gavotting1443193gavotting
gazetting2043243gazetting
gelding103911793g__elding
gilling93520383g__illing
governing1435533governing
greenling1136753greenling
grilling103811533g_rilling
groveling1435573grove_ling
grueling1078273grue_ling
gruellings1272323gruellings
gulling94019563g__ulling
hanselling1445623hanselling
havening15258553have_ning
havering152211053have_ring
helling114623223__helling
hoveling15189593hove_ling
impelling1436913impelling
javelin17306983jave_lin_
javelina18315453jave_lina
javelining2142513javelining
javelins18277733jave_lins
jelling153516613__jelling
jewelling2034833jewelling
knelling13319023_knelling
labeling11311643labe_ling
lalling83519623la__lling
laurelling1144463laurelling
laveering1336813laveering
leveling122910433leve_ling
libelling1236873libelling
malling103623663ma__lling
marcelling1545593marcelling
marveling1537103marve_ling
melling102822623__melling
modelling1336883modelling
palling104024483pa__lling
paneling111013623pane_ling
panellings1344533panellings
parcelling1546173parcelling
quelling18259793_quelling
rappelling1544363rappelling
ravelin102211023rave_lin_
ravelings13377383rave_lings
ravelins113011603rave_lins
ravening122611293rave_ning
rebelling122111163rebelling
refelling132211313refelling
repelling122312753repelling
reselling102213833reselling
retelling102112493retelling
revealing132611883revealing
reveling123117083reve_ling
rivalling1335963rivalling
rowelling1366993rowelling
selling83225833__selling
shaveling1646843shave_ling
shelling123515213_shelling
shovelling1744063shovelling
smelling113712723_smelling
snelling93913563_snelling
snivelling1444293snivelling
spelling113315233_spelling
swelling123212753_swelling
swivelling1743413swivelling
tasselling1145233tasselling
teaselling1145333teaselling
teazelling2043803teazelling
telling83321083__telling
towelling1366253towelling
tramelling1346373tramelling
traveling1349053trave_ling
unravelling1543153unravelling
unselling10810333unselling
unveiling1337723unveiling
upwelling1535233upwelling
vealing114217423__vealing
veiling113615293__veiling
walling113520973wa__lling
wavellite1543943wavellite
wavering152410543wave_ring
weaselling1454233weaselling
welling112920313__welling
yelling113516703__yelling
yodelling1435193yodelling

Search took 9 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.423422437.4
2DLD Change Limit1486411617.65619415.0
3Display Results1611610.1061518.9
 (SQL Overall)1786911618.18521831.5
 
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.