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

194 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
panelling123907(None) 
paneling111013621pane_ling
panellings1344531panellings
aneling82719502_ane_ling
canalling1239552canalling
cancelling1547212cancelling
empanelling1662412empanelling
gavelling14286872gavelling
hanselling1445622hanselling
impanelling1652622impanelling
knelling13319022_knelling
labelling1238082labelling
palling104024482pa__lling
panelings12107452pane_lings
parcelling1546172parcelling
ravelling13269242ravelling
repanelling1443472repanelling
snelling93913562_snelling
spancelling1643342spancelling
anearing9413973_anearing
angeling102811733_angeling
angling92816043_an_gling
ankling122912063_an_kling
annealing1047453annealing
annulling1045003annulling
anviling1239743_anviling
anvilling1336833_anvilling
appalling1444923appalling
apparelling1652433apparelling
appealing1446493appealing
balling104424763ba__lling
bantling112612003ban_tling
barrelling1345453barrelling
belling103825073__belling
bevelling15227453bevelling
bowelling1566493bowelling
caballing1436883caballing
cageling12310843cage_ling
calling103826773ca__lling
canaling112016413can_aling
canceling14310163canceling
candling122313873can_dling
capellini1345263capellini
carolling1259413carolling
cavilling1536393cavilling
celling103921263__celling
chandelling1844453chandelling
channelling1743993channelling
crenelling1345683crenelling
cupelling1436283cupelling
dandling112511733dan_dling
dangling112611233dan_gling
dowelling1466253dowelling
duelling103410733_duelling
dwelling13368413_dwelling
eanling81416673ean__ling
empaneling1573403empane_ling
enamelling1344313enamelling
excelling1935643excelling
expelling1936133expelling
falling113621583fa__lling
felling113321133__felling
flannelling1542833flannelling
fuelling123410153_fuelling
funnelling1444243funnelling
galling93921963ga__lling
gangling112411403gan_gling
gaveling133410163gave_ling
gelling93219763__gelling
gravelling1565213gravelling
gruelling1155603gruelling
handling132312713han_dling
handselling1642823handselling
hanseling1338063hanseling
helling114623223__helling
hovelling1636163hovelling
impaneling1573373impane_ling
impelling1436913impelling
jangling17249623jan_gling
jelling153516613__jelling
jewelling2034833jewelling
kennelling1573863kennelling
kernelling1584143kernelling
kneeling13287783_kneeling
knolling13206893_knolling
kvelling16146513_kvelling
labeling11311643labe_ling
lalling83519623la__lling
laurelling1144463laurelling
levelling13206973levelling
libelling1236873libelling
malling103623663ma__lling
manacling1446283manacling
mangling122312623man_gling
mantling112012613man_tling
marcelling1545593marcelling
marvelling1645363marvelling
melling102822623__melling
modelling1336883modelling
monellin1047373monellin_
monellins1147423monellins
nilling83619563__nilling
nulling83818063__nulling
paddling13218643pa_ddling
painkilling1852303painkilling
paling93530133pa___ling
palleting1238743palleting
palming123914013pa__lming
palping124112873pa__lping
pancaking1836383pancaking
pandering133211963pandering
pandying15217663pan_dying
panelist10414503pane_list
panelled1138963panell_ed
panfrying1842993panfrying
panging113319113pan__ging
pangolin1147773pangolin_
pangolins1247373pangolins
panicking1835293panicking
panning104019393pan__ning
panting104025423pan__ting
papering132213313pape_ring
parceling1438443parceling
parenting12611583parenting
parleying1536113parleying
parling103823763pa__rling
paroling113316213pa_roling
patenting1248943patenting
patrolling1345693patrolling
pealing104123203p__ealing
pedalling1346663pedalling
peeling102919873p__eeling
pelting102917273p__elting
penciling1437413penciling
pencilling1545473pencilling
perilling12410003perilling
pilling103722563p__illing
pinballing1544013pinballing
pindling122110983pin_dling
polling102920383p__olling
pommelling1743613pommelling
preselling1338693preselling
pretelling1338133pretelling
prilling113413413p_rilling
propelling1556933propelling
pulling103821073p__ulling
pummelling1743163pummelling
pungling12228663pun_gling
quelling18259793_quelling
rankling132610113ran_kling
rappelling1544363rappelling
raveling123414373rave_ling
ravellings14214453ravellings
rebelling122111163rebelling
refelling132211313refelling
repaneling1345733repane_ling
repelling122312753repelling
reselling102213833reselling
retelling102112493retelling
revelling132412553revelling
rowelling1366993rowelling
sandaling112010563sandaling
sandalling1245873sandalling
sanderling1256653sanderling
sandling102214413san_dling
selling83225833__selling
shelling123515213_shelling
smelling113712723_smelling
spalling113213463spa__lling
spanceling1543943spanceling
spangling1336373span_gling
spelling113315233_spelling
swelling123212753_swelling
tangling101712543tan_gling
tasselling1145233tasselling
teaselling1145333teaselling
teazelling2043803teazelling
telling83321083__telling
tinselling1145523tinselling
towelling1366253towelling
tramelling1346373tramelling
travelling1456533travelling
tunnelling1144383tunnelling
unselling10810333unselling
upswelling1643363upswelling
upwelling1535233upwelling
vanillin1145913vanillin_
vanillins1245553vanillins
walling113520973wa__lling
wangling132310993wan_gling
weaselling1454233weaselling
welling112920313__welling
yelling113516703__yelling
yodelling1435193yodelling

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411946.47022973.9
3Display Results1941940.0932086.0
 (SQL Overall)1786911946.98325589.4
 
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.